Cancelled registrations · 21

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 = 'NY' AND d.registrant_city = 'KENMORE' 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 = 'NY' AND d.registrant_city = 'KENMORE'
  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 = 'NY' AND d.registrant_city = 'KENMORE'
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.

N881AVR4robotics R4 COMPACT ROLLER · S/N R4CR0720202Cancelled Jan 11, 2022 · Sale reported, canceled N666NZ3D Robotics SOLO · S/N 121BCancelled May 31, 2018 · Sale reported, canceled N29577Taylorcraft BF · S/N 2420Cancelled Mar 23, 2018 · Revoked, canceled · Built 1940 · Caneen Jerome A N39369Aeronca 65-TAC · S/N C4342TACancelled Nov 18, 2017 · Revoked, canceled · Built 1942 · Hollands Ted B N5798MCessna 310P · S/N 310P0098Cancelled Aug 27, 2012 · Revoked, canceled · Built 1969 · Harold Laverne Bucholtz Inc N50972Cessna 172L · S/N 17259681Cancelled Jul 10, 1984 · Exported to Canada · Kenebuc Buffalo Inc N6579KRepublic RC-3 · S/N 852Cancelled Oct 11, 1974 · Nichols Donald Edward N27733Stinson 10A · S/N 7672Cancelled Dec 31, 1970 · Favale Frank S N3667EAeronca 7AC · S/N 7AC-6980Cancelled Feb 8, 1967 · Exported to Canada · Transit Acft Salvage & Repair Corp N35174Piper J3L-65 · S/N 6163Cancelled May 20, 1965 · Frank S Favale N9621KStinson 108-2 · S/N 2621Cancelled May 4, 1961 · Exported to Canada · Transit Aircraft Salvage & Repair Corp N5605HPiper PA-16 · S/N 16-212Cancelled Aug 26, 1959 · Exported to Canada · Built 1949 · Favale Frank S N51885Fairchild PT-19A · S/N T42-3578Cancelled Oct 24, 1955 · Built 1942 · Hall Ralph Gordon N75120Consolidated Vultee BT-15 · S/N 7630Cancelled Oct 24, 1955 · William George Hawkins N92510Piper PA-12 · S/N 12-33Cancelled Jul 15, 1949 · Bensen Richard K N80788Globe GC-1A · S/N 191Cancelled May 26, 1949 · Washburn Lloyd N29340Waco UPF-7 · S/N 5367Cancelled Nov 8, 1948 · Benson Richard K N30706Piper J3C-65 · S/N 5056Cancelled May 1, 1943 · Built 1940 · Benson Richard A N15887Porterfield 35V · S/N 200Cancelled Sep 1, 1940 · Holloway Robert L N12527Beazley Nicholas 8G · S/N K-57Cancelled Jun 1, 1938 · Built 1932 · Thompson Harold J N781YMoles Howard R/Kerr John A MOLES/KERR SPECIAL · S/N 1Cancelled Aug 17, 1935 · Built 1931 · Moles Howard R & Kerr John A

Back to Kenmore, NY