Skip to content

Cancelled registrations · 44

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 = 'FL' AND d.registrant_city = 'DANIA' 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 = 'FL' AND d.registrant_city = 'DANIA'
  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 = 'FL' AND d.registrant_city = 'DANIA'
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.

N81947Aeronca 7AC · S/N 7AC-572Cancelled May 18, 2020 · Revoked, pending cancellation · Built 1946 · Owens Dale C N30CLCessna 210E · S/N 21058695Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1965 · Weisman James P N700EPBeech 65-80 · S/N LD-144Cancelled Dec 2, 2014 · Revoked, canceled · Built 1964 · Pannell M Joseph N8279GBeech 400A · S/N RK-79Cancelled Oct 16, 2014 · Built 1993 · Tx Investments LLC N5101CBeech B35 · S/N D-2381Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1950 · Walker Gale D N3234RCessna 411 · S/N 411-0234Cancelled Sep 30, 2014 · Registration expired, pending cancellation · Built 1966 · Glade Air Inc N9019YPiper PA-31-310 · S/N 31-27Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Glade Air Inc N63JKPiper PA-23-250 · S/N 27-3571Cancelled Aug 5, 2013 · Revoked, canceled · Built 1966 · Flying Cs Inc N31ABPiper PA-30 · S/N 30-743Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1965 · Adb Engineers Inc N808RHDehavilland DH104 DOVE 6A · S/N 04040Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1947 · Terry Robert M N673RDehavilland DH104 DOVE 6A · S/N 04327Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1952 · Terry Robert M N6297BAero Commander 680-E · S/N 680-619-247Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1958 · Lee Theresa S N345XBeech 65-80 · S/N LD-141Cancelled Apr 23, 2013 · Sale reported, canceled · Built 1964 N52288Boeing A75N1(PT17) · S/N 75-1402Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1941 · Bush Aviation Inc N52525Boeing E75 · S/N 75-031Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1937 · Bush Charles E N4263CDehavilland DH104 DOVE 6A · S/N 04310Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1951 · Terry Robert M N275MCessna 310 · S/N 35375Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1956 · Bridges Porter N7022YHawker Beechcraft B200 · S/N BB-1982Cancelled Oct 27, 2010 · Exported to Brazil · Built 2007 · International Aircraft Trading LLC N36VFRaytheon 58 · S/N TH-2039Cancelled Oct 1, 2009 · Exported to Brazil · International Aircraft Trading LLC N337JHCessna T337C · S/N 337-0790Cancelled Mar 8, 2005 · Exported to Mexico · Goebel Ernest J N9728HCessna 172M · S/N 17266337Cancelled Dec 8, 1999 · Triennial form not returned · Mark Koral Holdings Ltd Inc N60DNCessna 402B · S/N 402B0326Cancelled Jul 25, 1994 · Triennial form not returned · Aviation Associates Inc N3024HPiper PA-28-181 · S/N 287990201Cancelled Sep 5, 1991 · Exported to France · C I D Trading Inc N847AHPiper PA-28-161 · S/N 288216072Cancelled Sep 5, 1991 · Exported to France · C I D Trading Inc N711TLBeech E18S · S/N BA-317Cancelled Nov 13, 1985 · Bush Aviation Inc N29417Cessna 177 · S/N 17700874Cancelled May 10, 1983 · Exported to Canada · Kuhn Dale Et Al N227CHEmbraer EMB-110P1 · S/N 110.206Cancelled Aug 3, 1981 · Exported to Colombia · Built 1979 · Aero Industries Inc N5971GCessna 150K · S/N 15071471Cancelled Mar 2, 1981 · Fulton William N3632Beech C18S · S/N 1449Cancelled Sep 1, 1976 · Built 1943 · Frost Howard N80006Beech D18S · S/N A-65Cancelled May 27, 1976 · Bush Aviation Inc N158MABritten-Norman BN-2A-8 · S/N 128Cancelled Dec 17, 1975 · Exported to Canada · Built 1975 · Moritz Ernest N94476Piper PA-23-250 · S/N 27-4560Cancelled Jun 27, 1974 · Exported to France · Moritz Ernest N80494Beech D18S · S/N A-328Cancelled Apr 24, 1974 · Bush Charles E N7318CLockheed 1649A-98 · S/N 1649A-1021Cancelled Feb 5, 1971 · Charles E Bosh N7301CLockheed 1649A-98 · S/N 1002Cancelled Oct 26, 1970 · Bush Charles E N6002CLockheed 749A-79 · S/N 2634Cancelled Sep 15, 1970 · Aviation Development Corp N62497Beech AT-11 · S/N 3229Cancelled Sep 15, 1970 · Bush Charles E N6278CBeech AT-11 · S/N 42-37674Cancelled Sep 15, 1970 · Charles E Bush N1274VBeech D18S · S/N 8058ACancelled Sep 14, 1970 · Bush Charles E N8082HLockheed 1649A-98 · S/N 1649A/1037Cancelled Feb 27, 1967 · Exported to South Korea · Bush Charles E N5845YPiper PA-23-250 · S/N 27-2995Cancelled Oct 22, 1965 · Exported to Kenya · Export Services Inc N5727YPiper PA-23-250 · S/N 27-2850Cancelled May 24, 1965 · Exported to Kenya · Export Services Inc N55119Boeing A75N1 · S/N 75-2391Cancelled Oct 28, 1963 · Exported to Nicaragua · Built 1946 · Bush Charles E N1642MBoeing A75L300 · S/N 75-8106Cancelled Jun 24, 1954 · Exported to Venezuela · Guaranteed Spraying & Dusting Inc

Back to Dania, FL