Skip to content

Cancelled registrations · 33

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 = 'MO' AND d.registrant_city = 'LIBERTY' 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 = 'MO' AND d.registrant_city = 'LIBERTY'
  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 = 'MO' AND d.registrant_city = 'LIBERTY'
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.

N9576UGrumman American Avn. AA-5A · S/N AA5A0266Cancelled Jul 13, 2023 · Built 1976 · Kruse Robert M N36448Taylorcraft BC12-D1 · S/N 3264Cancelled Jun 3, 2023 · Revoked, canceled · Built 1941 · Baldridge H R N704HSCessna 150M · S/N 15078629Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1976 · Rebel Aviation Inc N42744Piper J3C-65 · S/N 15046Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 1945 · Gooch Austen J N1513JPiper PA-28-140 · S/N 28-23907Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1967 · Wirt Charles J N610PCPiper PA-23-250 · S/N 27-2916Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1965 · Rebel Aviation Inc N500KXConnors R W/Connors K N REVOLUTION MINI 500 · S/N 424Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2000 · Connors Robert W N5172UTurner Richard L STILETTO · S/N 10025Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1985 · Turner Richard L N60221Boeing A75N1(PT17) · S/N 75-2159Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1941 · Rebel Aviaton Inc N6459EDanner Eric C RANS-12 AIRAILE · S/N 0592225Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1993 · Danner Eric C N1178JBoeing N2S-3 · S/N 757685Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1946 · Duckworth Edward I N197RTTurner Richard L MACHETE · S/N 5001Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Turner Richard L N7537FChampion 7KCAB · S/N 278-70Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Built 1970 · Raasch Errie W N5171NStarlight Mfg STARLIGHT XC2000 · S/N 5025Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1984 · Starflight Mfg Inc N6730ACessna 172 · S/N 28830Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1956 · Kruse Robert M N5608ACessna 172 · S/N 28208Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1956 · Hart James B N192SBCessna T206H · S/N T20608112Cancelled Mar 25, 2013 · Exported to Australia · Built 1999 · D & F Aviation LLC N82034Aeronca 7AC · S/N 7AC-660Cancelled Oct 3, 2012 · Sale reported, canceled · Built 1946 N3204VBeech 35 · S/N D-641Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1947 · Dickerson Stephen Ray N2249DCessna 170B · S/N 20401Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1952 N106CLDiamond Aircraft Ind DA20-C1 · S/N C0006Cancelled Jun 4, 2009 · Exported to Canada · Built 1998 · Caldwell Joshua A N7007HPiper J3C-65 · S/N 20252Cancelled Aug 11, 2006 · Triennial form not returned · Built 1946 · Morgan James J N48920Cessna 152 · S/N 15281049Cancelled Mar 10, 2005 · Triennial form not returned · Built 1977 · Duckworth Edith N235DAPiper PA-28-235 · S/N 28-10968Cancelled Oct 29, 2001 · Triennial form not returned · Built 1967 · Camper John R N211DTSportavia-Putzer FOURNIER R.F.5 · S/N 5037Cancelled Mar 17, 1999 · Triennial form not returned · Morrow Ben N4278EPiper PA-38-112 · S/N 3878A0525Cancelled Aug 24, 1994 · Triennial form not returned · Liberty Flight Center N68729Cessna 152 · S/N 15282342Cancelled Jun 23, 1993 · Second triennial mailing, no response · Duckworth Edward I Jr N533DFFetters Dennis L COMMANDER COMMANDO · S/N 0004GMCancelled May 22, 1991 · Triennial form not returned · Fetters Dennis L N92517Piper PA-12 · S/N 12-40Cancelled May 4, 1978 · Harness Guy E N50979Taylorcraft DCO-65 · S/N 5926Cancelled Jun 25, 1973 · Harness Guy Edward Jr & John Elyen Alley N96298Taylorcraft BC12-D · S/N 8598Cancelled Nov 21, 1972 · Built 1946 · Harness Guy E Jr N47528Aeronca 0-58B · S/N 10403Cancelled May 12, 1960 · Built 1944 · Crawford William Norton N704BBeech A35 · S/N D1709Cancelled Oct 31, 1950 · Parrish Claude

Back to Liberty, MO