Skip to content

Cancelled registrations · 111

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 = 'CA' AND d.registrant_city = 'COMPTON' 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 = 'CA' AND d.registrant_city = 'COMPTON'
  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 = 'CA' AND d.registrant_city = 'COMPTON'
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.

N27WTPiper PA-31P · S/N 31P-7530027Cancelled Apr 18, 2024 · Registration pending, canceled · Built 1975 N3474Alfoos Minicab COUPE · S/N 1Cancelled Nov 11, 2023 · Sale reported, canceled N527CBPiper PA-31P · S/N 31P7730001Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1977 N23680Piper PA-38-112 · S/N 38-81A0153Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1981 · Torrance Aeronautical Museum N4644QCessna 152 · S/N 15285046Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1981 · Tomorrows Aeronautical Museum N58WRBell OH-58C · S/N 70-15258Cancelled Jul 16, 2021 · Registration expired, pending cancellation · Built 1971 · Tomorrows Aeronautical Museum Inc N513BPiper PA-23-250 · S/N 27-416Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Tomorrows Aeronautical Museum Inc N6259VCessna 172RG · S/N 172RG0600Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1980 · Tomorrows Aeronautical Museum Inc N5440FNorth American T-28B · S/N 138294Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1956 · Tomorrows Aeronautical Museum N723KLPipistrel Lsa S R L ALPHA ELECTRO · S/N 834 AE 60Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Tomorrows Aeronautical Museum Inc N2475KPiper PA-38-112 · S/N 38-79A0656Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1979 · Tomorrows Aeronautical Museum Inc N722KLPipistrel Lsa S R L ALPHA ELECTRO · S/N 831 AE 60Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2017 · Tomorrows Aeronautical Museum Inc N734SVCessna 172N · S/N 17269085Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1977 · Tomorrows Aeronautical Museum N32GBLockheed/Butterworth BTTWRTH LCKHEED T33 · S/N 536091GNB89-2Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Tomorrows Aeronautical Musuem N19494Cessna 150L · S/N 15074449Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1973 · Tomorrows Aeronautical Museum N66880Consolidated Vultee BT-13A · S/N 2567Cancelled Mar 20, 2020 · Revoked, canceled · Built 1941 · Hobbs Merle N7864ZCessna 150C · S/N 15059964Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Tomorrows Aeronautical Museum Inc N6068MStinson 108 · S/N 1084068Cancelled Aug 5, 2019 · Revoked, canceled · Built 1947 · Berg Gene I N4290VCessna 170 · S/N 18648Cancelled May 15, 2019 · Revoked, pending cancellation · Built 1948 · A W Brothers N8580KStinson 108 · S/N 108-1580Cancelled Apr 6, 2018 · Revoked, canceled · Built 1947 · Pate Robert N86305Aeronca 11AC · S/N 11AC-111Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Brown Richard V N95143Taylorcraft BC12-D · S/N 9543Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Henderson Harlen V N1636KLuscombe 8A · S/N 4363Cancelled Mar 23, 2018 · Revoked, canceled · Built 1946 · Thompson Mark A N26908Gulfstream American AA-5A · S/N AA5A0805Cancelled Feb 27, 2018 · Built 1979 · Tomorrow'S Aeronautical Museum Inc N7506WPiper PA-28-180 · S/N 28-1418Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1963 · Tomorrows Aeronautical Museum N3778HEngineering & Research ERCOUPE 415-C · S/N 4403Cancelled Nov 22, 2017 · Revoked, canceled · Built 1947 · Gilbertson Bert N1062BMooney M20A · S/N 1289Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1958 · Kruse Eugene M Jr Co Ow N6405YRebaya Ralph M BENSON B8-M · S/N RR-001Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Rebaya Ralph M N400FMLevy John Crowell JR LANCAIR IV · S/N 147Cancelled May 15, 2017 · Registration expired, pending cancellation · Martinez Francisco N7817FCessna 150F · S/N 15063917Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1966 · Aberle Harry L DBA N6789CBladerunner 1993 BLADERUNNER · S/N JL10/93-1ACancelled Nov 20, 2014 · Registration expired, pending cancellation · Aisha Development Corp N78637Piper PA-11 · S/N 111398Cancelled Sep 24, 2014 · Revoked, pending cancellation · Built 1947 · Compton Air College Inc N7063LRobinson Helicopter R22 BETA · S/N 2946Cancelled Mar 17, 2014 · Exported to Australia · Built 1999 · Celebrity Helicopters Inc N6689CBeech C18S · S/N 5626Cancelled Sep 26, 2013 · Revoked, canceled · Johnson R B N6275QCessna 401A · S/N 401A0075Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1969 · Newsom Robert V N6516GCessna 150L · S/N 15072016Cancelled Aug 6, 2013 · Revoked, canceled · Built 1970 · Coe Robert D N8916SCessna 150A · S/N 15062216Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1965 · Benner Elmer E DBA N260DWCessna T210L · S/N 21061061Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1975 · Custom Sales Inc N5312LCessna 152 · S/N 15284294Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1980 · Consolidated Avn Corp DBA N835FCPiper PA-28-140 · S/N 28-22226Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1966 N4730VDouglas C-47B · S/N 33572Cancelled Sep 12, 2012 · Revoked, canceled · Built 1952 · Mansdorf Lee And Co N4144BAero Commander 520 · S/N 520-49Cancelled Feb 28, 2011 · Revoked, pending cancellation · Built 1953 · Duarte Charles N911JNBell OH-58C · S/N 68-16751Cancelled Aug 15, 2000 · Triennial form not returned · City Of Compton N4595PPiper PA-23-250 · S/N 27-104Cancelled Aug 23, 1982 · Built 1960 · 47 Flying Service Inc N2702JHughes 369HS · S/N 1140672SCancelled Dec 1, 1981 · Exported to Japan · Built 1974 · Consolidated Aviation Corp N5497KCessna 172P · S/N 17274162Cancelled Aug 17, 1981 · Exported to Japan · Consolidated Aviation Corp DBA Compton Aviation N9899ZCessna 310B · S/N 35605Cancelled Apr 26, 1974 · Floyd Booker T N1578SBeech P35 · S/N D-6998Cancelled Mar 26, 1974 · Built 1962 · Compton Truck & Equipment Co N2035CBeech 95 · S/N TD-200Cancelled Dec 3, 1973 · Commercial Grinding Co Inc N8341HEmigh TROJAN A-2 · S/N 44Cancelled May 7, 1973 · Daily H E

Back to Compton, CA