Skip to content

Cancelled registrations · 18

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 = 'MD' AND d.registrant_city = 'LAUREL' 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 = 'MD' AND d.registrant_city = 'LAUREL'
  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 = 'MD' AND d.registrant_city = 'LAUREL'
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.

N868HAJohns Hopkins Univ APL Physics GAMERA · S/N 005Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Johns Hopkins Univ Applied Physics Laboratory LLC N871SJJohns Hopkins Univ APL Physics GAMERA · S/N 001Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Johns Hopkins Univ Applied Physics Laboratory LLC N869VJJohns Hopkins Univ APL Physics GAMERA · S/N 002Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Johns Hopkins Univ Applied Physics Laboratory LLC N544JDJohns Hopkins Univ APL Physics GAMERA · S/N 004Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Johns Hopkins Univ Applied Physics Laboratory LLC N5919WPiper PA-28-150 · S/N 28-3217Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1966 · Hardy Thomas L N5405ZPiper PA-22-108 · S/N 22-9177Cancelled Nov 20, 2017 · Revoked, canceled · Built 1961 · Suburban Airservice Inc N6243PPiper PA-24-250 · S/N 24-1348Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1959 · Ward Clarence H Jr N5424FPiper PA-28-140 · S/N 28-7725057Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1976 · Engle Margaret Jo N735NACessna 182Q · S/N 18265544Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1977 · Souder Bruce D N430GSStepanenko George FOXTROT · S/N F002Cancelled Aug 27, 2013 · Sale reported, canceled N6036DPiper PA-22-150 · S/N 22-4689Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1956 · Eldridge Gary L N14432Semco Balloon T · S/N SEM-64Cancelled Jun 30, 2009 · Registration revoked · Built 1972 · Freitag William L N40RRaum Ronald A RANS S-12 AIR · S/N 0891117Cancelled Oct 23, 2001 · Triennial form not returned · Built 1991 · Harab Joseph D N2513NPiper PA-38-112 · S/N 3879A0883Cancelled Jan 11, 1995 · Triennial form not returned · Altman Glenn I N1GHCessna 172M · S/N 17261288Cancelled Jan 8, 1993 · Registration revoked · Hotelling G A N64759Bucker Jungmann C.A.S.A. 1.131 · S/N 2159Cancelled Jan 11, 1982 · Sperling Richard N99981Engineering & Research 415-C · S/N 2604Cancelled Jul 7, 1970 · Laurel Volunteer Rescue Squad Inc N5079WPiper PA-28 · S/N 28-88Cancelled May 20, 1965 · Suburban Airservice

Back to Laurel, MD