Cancelled registrations · 19

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 = 'TX' AND d.registrant_city = 'DECATUR' 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 = 'TX' AND d.registrant_city = 'DECATUR'
  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 = 'TX' AND d.registrant_city = 'DECATUR'
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.

N555HHGrumman American Avn. AA-1B · S/N AA1B-0172Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1973 · Crohan Michael L N43054Taylorcraft BC12-D · S/N 6713Cancelled Jul 23, 2022 · Registration expired, pending cancellation · Built 1946 · Peterson John W N407NPBell 407 · S/N 53651Cancelled Jan 4, 2022 · Exported to Panama · Built 2005 · Aerobrigham LLC N528ABBell 407 · S/N 53527Cancelled Sep 8, 2020 · Exported to Panama · Aerobrigham LLC N5838VSchweizer SGU 2-22E · S/N 206Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1964 · North Texas Soaring N3297CBeech E35 · S/N D-3964Cancelled Jan 3, 2020 · Sale reported, canceled · Built 1954 N133LGDJI PHANTOM 3 STANDARD · S/N P76DC129A20604Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lgc3 Group Inc N7013RPiper PA-28-140 · S/N 28-21707Cancelled Jul 22, 2019 · Exported to Mexico · Built 1966 · Lucier Jared M N611CBCessna 208B · S/N 208B1092Cancelled Mar 30, 2018 · Exported to Colombia · Built 2004 · Ttc Aircraft Leasing Inc N8220RBellanca 17-30A · S/N 30430Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1972 · Spence William C N6923GCessna 150L · S/N 15072423Cancelled Mar 22, 2011 · Exported to Argentina · Built 1970 · Polhemus John W N8173VCessna A188 · S/N 188-0423Cancelled Nov 20, 2007 · Exported to Argentina · Built 1968 · Texas Air Cargo Inc N394RPilatus Porter PC-6/C-H2 · S/N 599Cancelled May 19, 2005 · Second triennial mailing, no response · Built 1966 · Bishop Tom N16MVBell 206B · S/N 4040Cancelled Nov 5, 2004 · Triennial form not returned · Built 1989 · Skylane Helicopters LLC N2691HSchweizer SGS 1-34 · S/N 91Cancelled Mar 15, 2004 · Triennial form not returned · Built 1976 · North Texas Soaring N7373TCessna 411 · S/N 411-0078Cancelled Mar 3, 1976 · American Omni Corp N45971Luscombe 8A · S/N 2498Cancelled Dec 9, 1975 · Hogue Jacky J N6204DAero Commander 680 · S/N 680-472-142Cancelled Jun 27, 1973 · Sportmans Air Taxi & Travel Club Inc N1018EAeronca 7AC · S/N 7AC-4569Cancelled Oct 4, 1951 · Armstrong J C

Back to Decatur, TX