Skip to content

Cancelled registrations · 40

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 = 'OWENSBORO' 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 = 'OWENSBORO'
  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 = 'OWENSBORO'
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.

N463WBPiper PA 46-350P · S/N 4622137Cancelled Jul 6, 2026 · Exported to Canada · Built 1993 · Rf Aviation LLC N632PBDassault MYSTERE-FALCON 20-F5 · S/N 355Cancelled Oct 24, 2025 · Exported to Canada · Built 1976 · Modern Transportation Company Inc N407BSLearjet 31 · S/N 033Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Jetone LLC N55BYCessna 310K · S/N 310K0145Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1966 · Perf-A-Lawn Inc N6892HDJI PHANTOM 3 PROFESSION · S/N CH271547323571Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Hayden Matthew N447CDeane Silas E CHALLENGER II · S/N 11SDCancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1990 · Deane Silas E N429BBCriquet Aviation Bogota Columb STORCH FI-156 · S/N CS 09008Cancelled May 30, 2018 · Sale reported, canceled · Built 2012 N3364GCessna 310R · S/N 310R1227Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1977 · Green Acre Title LLC N38AKBeech B-99 · S/N U-158Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1974 · Air Kentucky Air Lines Inc Trustee N5869RCessna 172G · S/N 17253538Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1965 · David Parker Leasing Co LLC N8164BCessna 172 · S/N 29964Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1957 N3001SBeech 95-B55 (T42A) · S/N TC-797Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1964 · Ratliff Byron O N414DTCessna 414 · S/N 414-0093Cancelled Jul 29, 2011 · Triennial form not returned · Built 1970 · Air Boomerang Inc N4231Stafford ED STAFFORD VANS RV-10 · S/N 40247Cancelled Jan 21, 2011 · Exported to Canada · Built 2008 · Stafford Ed H N390HCAero Vodochody L-39ZA · S/N 432832Cancelled Nov 19, 2010 · Exported to San Marino · Built 1984 · Cannon Harold C N149JHBritish Aerospace BAE JETSTREAM 3201 · S/N 947Cancelled Aug 11, 2006 · Exported to Greece · Built 1991 · Mid America Jet Inc N359GTGreen Tree MINI 500 · S/N 315Cancelled Jun 9, 2005 · Timco Aircraft Corp N18HZCessna 172M · S/N 17266378Cancelled Apr 11, 1998 · Triennial form not returned · Martin Aviation Inc N120TWBeech 58 · S/N TH537Cancelled Jan 22, 1997 · Triennial form not returned · Venture Aviation Inc N64098Cessna 172M · S/N 17265017Cancelled Jan 19, 1996 · Triennial form not returned · Duke Walter Jr N96926Cessna 172P · S/N 17276135Cancelled Jun 26, 1991 · Exported to Canada · Bullfrog Inc N2532ABeech V35A · S/N D-9042Cancelled Jan 13, 1984 · Administratively canceled · Lyman S Cox Jr DBA Owensboro Aviati N4649EAeronca 7EC · S/N 7EC-2Cancelled Feb 5, 1971 · Cox Jr Lyman Sdba Owensboro Aviation N1828EAeronca 7AC · S/N 7AC-5395Cancelled Jun 26, 1970 · Cox Lyman S Jr N8889Beech C-45 · S/N 12373Cancelled Oct 14, 1969 · Daviess County High School N57628Ryan Aeronautical ST3KR · S/N 2205Cancelled May 25, 1965 · Dewey James A Etal N86244Aeronca 11AC · S/N 11AC-48Cancelled Feb 23, 1956 · Marks Houston J N61781Cessna T-50 · S/N 5814Cancelled Feb 15, 1956 · Compton R Hal N61502Cessna T-50 · S/N 6616Cancelled Oct 12, 1955 · Ayer Noble N46631Fairchild M-62A · S/N 324-SLCancelled Oct 10, 1955 · Ayer Noble N609YWaco RNF · S/N 3332Cancelled Nov 23, 1951 · Harden James & James Wood N1905NCessna 120 · S/N 12149Cancelled Jul 27, 1951 · Ayer Noble N19751Aeronca K · S/N 267Cancelled Jun 26, 1950 · Stiles D E N85672Aeronca 7AC · S/N 7AC-4417Cancelled Jun 17, 1949 · Ccil Elmo Merideth N2862EAeronca 7AC · S/N 7AC-6445Cancelled Jun 9, 1949 · Cox Lyman S Jr N84760Aeronca 7AC · S/N 7AC-3473Cancelled Jun 1, 1949 · Noble Ayer N36999Aeronca 65-TAL · S/N 3042Cancelled Jan 5, 1949 · Built 1942 · Owensboro Aviation N893WBird BK · S/N 2034-10Cancelled Jul 8, 1948 · Curtis Leo Frank N639Waco ATO · S/N A-803Cancelled Apr 15, 1935 · Built 1927 · Tribble Clifton N9478EAeronca 11AC · S/N 11AC-1114Cancellation date not recorded · Built 1946 · Cox S Lyman Jr

Back to Owensboro, KY