Skip to content

Cancelled registrations · 27

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

N483KLLockheed Martin DESERT HAWK EER · S/N AV-0001Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Lockheed Martin Corp N442SBLockheed Martin INDAGO · S/N 3579Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Lockheed Martin Corp N4797CLockheed Martin DESERT HAWK III · S/N AV-N00BCancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Lockheed Martin Corp N480NCLockheed Martin DESERT HAWK III · S/N AV-N00ACancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Lockheed Martin Corp N483HLLockheed Martin DESERT HAWK EER · S/N AV-0003Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Lockheed Martin Corp N483JLLockheed Martin DESERT HAWK EER · S/N AV-0002Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Lockheed Martin Corp N483MKLockheed Martin DESERT HAWK IIIK · S/N AV-0452Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Lockheed Martin Corp N483PKLockheed Martin DESERT HAWK IIIK · S/N AV-0454Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Lockheed Martin Corp N483QKLockheed Martin DESERT HAWK IIIK · S/N AV-0453Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 2012 · Lockheed Martin Corp N575BSLockheed Martin DESERT HAWK IIIK · S/N NAIR001Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Lockheed Martin Corp N599HSLockheed Martin DESERT HAWK IIIK · S/N NAIR002Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Lockheed Martin Corp N474LLLockheed Martin DESERT HAWK III · S/N AV-0569Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2011 · Lockheed Martin Corp N483NYLockheed Martin VECTOR HAWK · S/N V120-2Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2015 · Lockheed Martin Corp N483TKLockheed Martin INDAGO · S/N 3500Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2014 · Lockheed Martin Corp N483TTLockheed Martin VECTOR HAWK V90 · S/N V90-2Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2015 · Lockheed Martin Corp N359KAKaman Aerospace K-1200 · S/N A94-0030Cancelled Jul 3, 2017 · Registration expired, pending cancellation · Built 2001 · Lockheed Martin Systems Integration N5204TBrainard Ted KING COBRA · S/N K-054-073-758Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Brainard Ted L N360KAKaman Aerospace K-1200 · S/N A94-0031Cancelled Jul 11, 2013 · Sale reported, canceled · Built 2001 N9587WPiper PA-28-140 · S/N 28-23034Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1967 · Goodrich Patrick B N3812Sailplane TERN · S/N AS-GS/WTM-6-69Cancelled Aug 17, 2004 · Triennial form not returned · Built 1969 · Phelps Craig R N2783Mcgovern WOODY PUSHER · S/N JM1918Cancelled Jun 28, 1972 · Built 1970 · Mcgovern James N2034KLuscombe 8 · S/N 4761Cancelled Jun 17, 1970 · Built 1947 · Tioga Plane Owners Assoc Inc N46394Fairchild M-62A · S/N T43-5406Cancelled May 20, 1965 · Charles Welty N235Camair 480 · S/N 1071Cancelled Oct 5, 1959 · Exported to Venezuela · Built 1948 · Dibble Roger N77864Luscombe 8A · S/N 3591Cancelled Aug 3, 1955 · Built 1946 · Shafer Orville B N8962HNorth American NAVION · S/N NAV-4-962Cancelled May 26, 1949 · Moreland Bert N2653Hess BLUEBIRD H-1 · S/N A-927Cancelled Feb 10, 1933 · Built 1926 · Leahy Eugene L

Back to Owego, NY