Skip to content

Bowling Green, KY

Cancelled registrations · 51

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'KY' AND d.registrant_city = 'BOWLING GREEN' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'KY' AND d.registrant_city = 'BOWLING GREEN'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_state = 'KY' AND d.registrant_city = 'BOWLING GREEN'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N495RJLearjet 45 · S/N 480Cancelled Oct 29, 2026 · Exported to Canada · Built 2014 · Big Sky LLC N5697UInfinity Power Parachutes COMMANDER 65 HP · S/N IPP7-352Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 2007 · Loafman Adam N1806Murphy Charles P SKY RAIDER · S/N 001Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2003 · Taylor Perry R N2560YInfinity CLASSIC · S/N IPP4-255Cancelled Jan 8, 2021 · Registration pending, canceled · Built 2004 N91814Lunceford Chuck SPARROWHAWK II · S/N S0200018Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 2008 · Lunceford Charles G N2646DReese Vernon E KR-2 · S/N K2-1073Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Hawkins William H N32745Blaylock William M CHALLENGER II · S/N CH2-0894-1202Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1995 · Akin Thomas G N735WWCessna 182Q · S/N 18265752Cancelled Dec 18, 2015 · Second renewal notice · Built 1977 · Mitchell-Stinson Holdings LLC N191JDRiehm James Dennis ROTORWAY EXEC · S/N 544Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1991 · Riehm James D N82PRRender James R RV-9A · S/N 487Cancelled Apr 23, 2015 · Built 2003 · Rohrer Douglas D N7163Lakebrink SPECIAL RL1 · S/N 1922Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1972 · Aircraft Maintenance Inc N986JDRiehm James Dennis RUTAN DEFIANT · S/N 44Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Riehm James Dennis N2912YCessna 182E · S/N 18253912Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1962 · Miller Donald P N303FBFantasy Sky Promotions SEVEN-65 · S/N 060Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1992 N317SHHonaker Shawn BOWERS FLYBABY 1A · S/N 73-20Cancelled Jun 6, 2013 · Third renewal notice · Honaker Shawn N3884Balcer Harry BI-PLANE · S/N HB100Cancelled May 10, 2013 · Registration pending, canceled N749CEPiper PA-31-310 · S/N 31-190Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1968 · Sales & Leasing N7293GCessna 172K · S/N 17258993Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1970 · Bowling Green Air Training Inc N5695SBeech A23-24 · S/N MA-96Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1966 N331KAAdams EVANS VP-1 · S/N KA1007Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1972 N2075HVelotta Mark LONG EZ · S/N 1030Cancelled May 18, 2012 · Registration expired, pending cancellation · Velotta Mark A N834ADDieball Alan C MURPHY RENEGADE · S/N 647Cancelled Jan 10, 2012 · Exported to South Africa · Built 2005 · Dieball Alan C N2644BAero Commander 560-A · S/N 346Cancelled Oct 13, 2011 · Sale reported, pending cancellation · Built 1956 N6131DCameron Balloons US N-90 · S/N 5451Cancelled Aug 6, 2010 · Triennial form not returned · Built 1988 · Lj Leasing LLC N4871NCessna 182Q · S/N 18267427Cancelled Mar 25, 2010 · Built 1979 · 4871n Inc N4007PCameron Balloons US Z-105 · S/N 6452Cancelled Mar 24, 2010 · Built 2006 · Robertson William D N44392Farmer Douglas N BENSEN B80 · S/N 04Cancelled Jun 26, 2009 · Triennial form not returned · Built 1983 · Farmer Douglas N N5323JGalaxy Balloons GALAXY 7 · S/N GLX-1697Cancelled May 29, 2009 · Triennial form not returned · Allen Mark S N127AZZobkiw Alex KR-2 · S/N ANZ-1Cancelled Oct 26, 2006 · Triennial form not returned · Zobkiw Alexander N7470UHarrell Kenneth RV-6 · S/N 21035Cancelled Mar 4, 2003 · Built 1996 · Harrell Kenneth N7JCCormmey SKYBOLT MODEL ONE · S/N 137Cancelled Dec 23, 2002 · Second triennial mailing, no response · Built 1972 · Cormney James D N321SBBleak S A/Bleak M W/Allen T LANCAIR IV · S/N LIV-079Cancelled Dec 5, 2002 · Exported to Mexico · Built 1994 · Sunbelt Construction Inc N9249UCessna 150M · S/N 15078199Cancelled May 20, 2002 · Triennial form not returned · Built 1976 · Honaker Shawn E N8991HNavion NAVION A · S/N NAV-4-991Cancelled May 5, 2000 · Triennial form not returned · London Flyers Inc N51164Cessna 150J · S/N 15069807Cancelled Jan 12, 2000 · Triennial form not returned · Pounds James J N392GLLucas Greg A MINI-MAX · S/N 392Cancelled Nov 10, 1999 · Triennial form not returned · Lucas Greg A N3207VCessna 150M · S/N 15076422Cancelled Nov 23, 1998 · Johnson Harry G N5494QCessna 150L · S/N 15073394Cancelled Aug 10, 1998 · Triennial form not returned · Mozingo Martin D N4405PWitherspoon Charles Arthur 1992-SP1 · S/N 11134Cancelled Jul 14, 1994 · Witherspoon Charles A N68RTBeech B90 · S/N LJ405Cancelled May 3, 1994 · Exported to Peru · Thompson Ronald H N2023HBalloon Works FIREFLY 6 · S/N 635Cancelled May 21, 1991 · Triennial form not returned · Napier James W III N182CMMyers Cecil R D-2 · S/N 1001Cancelled Nov 21, 1990 · Meyers Cecil R N9164YPiper PA-31-310 · S/N 31-217Cancelled Jan 22, 1985 · Administratively canceled · Turbo Sales And Leasing N747CEPiper PA-31-310 · S/N 31-673Cancelled Dec 14, 1982 · Aircraft Maintenance Inc N18152Cessna 150L · S/N 15073825Cancelled Jan 30, 1980 · Exported to Canada · Built 1972 · Aircraft Maintenance Inc N2196GCessna 182A · S/N 51496Cancelled May 8, 1975 · Madison L C N6543DFarmer MODERN GYRO · S/N FW-21614Cancelled Sep 24, 1970 · Farmer Douglas N Etal N3389TCessna 177 · S/N 17700689Cancelled Jun 29, 1970 · Bridges Aircraft Sales & Service Inc N50494Cessna T-50 · S/N 5829Cancelled Feb 3, 1949 · Stuart M W N13343Cessna T-50 · S/N 1931Cancelled Jul 19, 1948 · Stuart Marvin Wooten

Back to Bowling Green, KY