Skip to content

Cancelled registrations · 42

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

N3510BBeech E35 · S/N D-3727Cancelled Jan 19, 2021 · Exported to Russia · Built 1954 · Buchen David E N50007Mackie Robert W MD MACKIE 1 · S/N 0068Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Wings Over Westchester Air Museum Inc N810QCBoeing 737-348 · S/N 23810Cancelled Jun 30, 2016 · Exported to Philippines · Met International Inc N2862LCessna 172H · S/N 17256062Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1967 · Perez-Villamil Jose R.N5161RCessna 172 · S/N 17263378Cancelled Sep 1, 1981 · Bedichek John G N9527QBeech 65 · S/N LC-239Cancelled Dec 22, 1971 · Sugihara Shigeyoshi N9059QBeech A36 · S/N E-232Cancelled Apr 23, 1971 · Exported to Japan · Shigeyoshi Suginhara N9104QBeech 58 · S/N TH-104Cancelled Mar 26, 1971 · Exported to Japan · Sugihara Shigeyoshi N9115QBeech A24R · S/N MC-57Cancelled Mar 3, 1971 · Exported to Japan · Sugihara Shigeyoshi N213FSBeech V35A · S/N D-8849Cancelled Feb 10, 1971 · Built 1968 · Boynton Studio Inc N3943ABeech A65 · S/N LC-334Cancelled Jun 12, 1970 · Exported to Japan · Shigeyoshi Sugihara N3941ABeech A65 · S/N LC-332Cancelled Jun 8, 1970 · Exported to Japan · Shigeyoshi Sugihara N3942ABeech A65 · S/N LC-333Cancelled Jun 8, 1970 · Exported to Japan · Shigeyoshi Sugihara N3945ABeech A65 · S/N LC-335Cancelled Jun 8, 1970 · Exported to Japan · Shigeyoshi Sugihara N4194ABeech 95-B55 (T42A) · S/N TC-1330Cancelled Apr 20, 1970 · Exported to Thailand · Sugihara Shigeyoshi N2091ABeech H-18 · S/N BA-765Cancelled Jan 27, 1970 · Exported to Japan · Shigeyoshi Sugihara N2072ABeech H-18 · S/N BA-761Cancelled Sep 8, 1969 · Exported to Japan · Shigeyoshi Sugihara N8078RBeech 36 · S/N E-156Cancelled Jun 24, 1969 · Exported to Japan · Built 1969 · Sugihara Shigeyoshi N7756RBeech A65 · S/N LC-324Cancelled May 19, 1969 · Exported to Japan · Sugihara Shigeyoshi N7536NBeech E33 · S/N CD-1189Cancelled Dec 13, 1968 · Exported to Japan · Sugihara Shigeyoshi N7533NBeech E33 · S/N CD-1187Cancelled Nov 26, 1968 · Exported to Japan · Sugihara Shigeyoshi N7532NBeech E33 · S/N CD-1186Cancelled Nov 25, 1968 · Exported to Japan · Sugihara Shigeyoshi N7534NBeech E33 · S/N CD-1188Cancelled Nov 25, 1968 · Exported to Japan · Sugihara Shigeyoshi N7537NBeech E33 · S/N CD-1190Cancelled Nov 6, 1968 · Exported to Japan · Shigeyoshi Sugihara N7538NBeech E33 · S/N CD-1191Cancelled Oct 29, 1968 · Exported to Japan · Shigeyoshi Sugihara N7539NBeech E33 · S/N CD-1192Cancelled Oct 29, 1968 · Exported to Japan · Shigeyoshi Sugihara N7752RBeech A65 · S/N LC-320Cancelled May 19, 1968 · Exported to Japan · Sugihara Shigeyoshi N7753RBeech A65 · S/N LC321Cancelled May 19, 1968 · Exported to Japan · Sugihara Shigeyoshi N7754RBeech A65 · S/N LC-322Cancelled May 19, 1968 · Exported to Japan · Sugihara Shigeyoshi N7755RBeech A65 · S/N LC-323Cancelled May 9, 1968 · Exported to Japan · Sugihara Shigeyoshi N7025NBeech H-18 · S/N BA-751Cancelled Nov 13, 1967 · Exported to Japan · Shigeyoshi Sugihara N5861JBeech 65 · S/N LC-161Cancelled Jul 21, 1965 · Exported to Japan · Sugihara Shigeyoshi N5862JBeech 65 · S/N LC-162Cancelled Jul 21, 1965 · Exported to Japan · Sugihara Shigeyoshi N5860JBeech 65 · S/N LC-160Cancelled Jun 21, 1965 · Exported to Japan · Suhihara Shigeyoshi N6820QBeech 65 · S/N LC-157Cancelled Sep 23, 1964 · Exported to Japan · Built 1964 · Sugihara Shigeyoshi N6821QBeech 65 · S/N LC-158Cancelled Sep 23, 1964 · Exported to Japan · Built 1964 · Sugihara Shigeyoshi N6822QBeech 65 · S/N LC-159Cancelled Sep 23, 1964 · Exported to Japan · Built 1964 · Sugihara Shigeyoshi N6416KRepublic RC-3 · S/N 661Cancelled Jan 2, 1959 · Mark Lawrence N57591Bell P39 · S/N 26E-433Cancelled Oct 11, 1955 · Haas Elizabeth N3321NPiper J3C-65 · S/N 22520Cancelled Oct 6, 1955 · Buechner Charles N3494EAeronca 7AC · S/N 7AC-6872Cancelled Jun 30, 1955 · Francis John Lavello N80144Culver V · S/N V-24ACancelled Nov 16, 1954 · Built 1946 · Mark Lawrence

Back to Scarsdale, NY