Skip to content

Cancelled registrations · 261

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

N502DBAir Tractor AT-502B · S/N 502B-0410Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1997 N6467ZPiper PA-25 · S/N 25-668Cancelled Aug 6, 2013 · Revoked, canceled · Built 1962 · Carlstein Ricardo G N1082LConsolidated Aeronautics LAKE LA-4 · S/N 675Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1975 · Mensing Rodger G N501KAero Commander 520 · S/N 520-12Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1952 · Diaz Carmen Samudio N7DCPiper PA-23-250 · S/N 27-3054Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1965 N717KWCessna T210L · S/N 21060816Cancelled Jun 24, 2013 · Exported to Mexico · Built 1975 · Alvarez Nestor E N36LSPiper PA-23-250 · S/N 27-7405253Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1973 · Mccutcheon Wesley R N7400VBeech E-90 · S/N LW-152Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1975 N656WConvair 240-12 · S/N 156Cancelled May 31, 2013 · Sale reported, canceled · Built 1949 N3404QCessna 404 · S/N 4040605Cancelled May 30, 2013 · Registration expired, pending cancellation · Aero Operating Company N9018NDouglas DC-6B · S/N 44425Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1954 · J M G Inc N901MBeech 95-B55 (T42A) · S/N TC-1379Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1970 · Escalante Cesar L N8707GCessna 150F · S/N 15062807Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1966 · Allen Russell J Jr N450MLMcdonnell Douglas DC-10-30F · S/N 47831Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1980 · Miami Leasing Inc N8235NPiper PA-28-140 · S/N 28-25442Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1969 · Molina Manuel Antonio N84179Aeronca 7AC · S/N 7AC-2867Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1946 · Warren Singleton N7814LBeech 65-B80 · S/N LD-338Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1967 · Rojas Jose R N6354CDouglas DC-7C · S/N 45111Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Belize Air Cargo Inc N6102Douglas DC3A · S/N 11645Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1943 · American Airways Charters Inc N568MABeagle B.206 SERIES 2 · S/N B206/066Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1968 · Justice Frank N5576VCessna 421 · S/N 421-0125Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1968 · Fuenmayor Winston A N5111DCessna 172N · S/N 17272425Cancelled Mar 25, 2013 · Registration expired, pending cancellation · Built 1979 · Aviation Financial Services Inc N8135Soucy DRAG-N-FLY · S/N 2Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1976 N29605Taylorcraft BL-65 · S/N 2447Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1940 · Kaufman Gene M N23019Cessna 150H · S/N 15068682Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1968 · North Dade Squadron Flying Club N600TMCessna 402B · S/N 402B0604Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1974 N3231XCessna 150G · S/N 15064631Cancelled Jan 31, 2013 · Sale reported, pending cancellation · Built 1966 N5229GCessna 305C (0-1E) · S/N 23599Cancelled Jan 30, 2013 · Sale reported, pending cancellation · Built 1956 N4982BBeech D-50 · S/N DH-45Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1956 N45WCessna 411 · S/N 411-0145Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1965 · Diaz Alberto Jonzalez N87640Douglas DC3C · S/N 9633Cancelled Nov 15, 2012 · Sale reported, pending cancellation N526MDMcdonnell-Douglas DC-10-30 · S/N 46998Cancelled Nov 1, 2012 · First renewal notice · Miami Leasing Inc N3462WPiper PA-32-260 · S/N 32-334Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1966 · Arenas Jose L N6167XAero Commander 680-F · S/N 680F-1048-56Cancelled Oct 3, 2012 · Sale reported, pending cancellation · Built 1961 N2531BConsolidated Vultee/Hops L-13A · S/N 47348Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1953 · Aeroists Intl Inc N2540XCessna P206 · S/N P2060040Cancelled Sep 12, 2012 · Registration expired, pending cancellation · Built 1965 · Mas Oscar N51131Lockheed 18-08 · S/N 2119Cancelled Aug 10, 2012 · Revoked, canceled · Built 1941 · Potomac Painters Inc DBA N4974Stiles TEENIE TW · S/N 5-10094Cancelled Aug 9, 2012 · Revoked, canceled · Stiles Gilbert L N490DMBeech D18S · S/N A-89Cancelled Aug 8, 2012 · Revoked, canceled · Built 1946 · Guell Julio Alfonso N1673XCessna T210L · S/N 21060708Cancelled Jul 19, 2012 · Sale reported, canceled · Built 1975 N1305MCessna T337G · S/N P3370152Cancelled Jun 21, 2012 · Registration expired, pending cancellation · Built 1973 · Carlson Peter N43592Taylorcraft BC12-D · S/N 7251Cancelled Jun 21, 2012 · Revoked, canceled · Built 1946 · Corliss Harry A N100BMBeech 65 · S/N LC-10Cancelled May 4, 2012 · Registration expired, pending cancellation · Built 1960 · Advanced Aircraft Lsg N11057Champion 7ECA · S/N 7ECA-69Cancelled Jul 20, 2011 · Sale reported, canceled · Built 1965 N10610Grumman G-44 · S/N 1281Cancelled Jun 29, 2011 · Sale reported, canceled · Built 1942 N82552Aeronca 7AC · S/N 7AC1189Cancelled Jun 24, 2010 · Registration revoked · Built 1946 · Flying W Ranch N32CCBeech C90 · S/N LJ-506Cancelled Jan 5, 2010 · Exported to Colombia · Built 1970 · Fuel Tradex Corp N47TEBeech F90 · S/N LA-96Cancelled Nov 18, 2008 · Exported to Germany · Built 1981 · European Investments Leasing LLC N4859QCessna A188B · S/N 18802595TCancelled Oct 21, 2008 · Sale reported · Built 1976 N47048Cessna 152 · S/N 15283161Cancelled Aug 15, 2008 · Exported to Bolivia · Built 1979 · Cylinder Shop Inc

Back to Hialeah, FL