Skip to content

Cancelled registrations · 40

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 = 'MA' AND d.registrant_city = 'LEXINGTON' 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 = 'MA' AND d.registrant_city = 'LEXINGTON'
  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 = 'MA' AND d.registrant_city = 'LEXINGTON'
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.

N7639DPiper PA-22-150 · S/N 22-5348Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Demontigny William D N8784ABeech C35 · S/N D-2207Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1950 · Trans Energy Company N4101PCessna O-2A · S/N 68-10868Cancelled Sep 17, 2013 · Registration expired, pending cancellation · East Coast Aero Technical School N2608APiper PA-38-112 · S/N 38-78A0774Cancelled May 31, 2013 · Sale reported, canceled · Built 1978 N97576Stinson 108 · S/N 108-576Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1946 N9866TPiper PA-38-112 · S/N 38-78A0226Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1978 N3045JCessna 150E · S/N 15061145Cancelled Aug 6, 2009 · Registration revoked · Built 1965 · Collins Thomas J N92PPiper PA-23-250 · S/N 27-4824Cancelled Mar 5, 2007 · Triennial form not returned · Built 1972 · Baskys Julius E N4648QCessna T210L · S/N 21059548Cancelled Jan 19, 2007 · Exported to Mexico · Built 1971 · Sandeen Mark D N5RHHall AX-6 · S/N 301Cancelled May 7, 2002 · Registration revoked · Built 1973 · Manning Charles G N8133ZPiper PA-32-300 · S/N 32-7940272Cancelled Apr 5, 2001 · Triennial form not returned · Perry Richard F N17976Schweizer SGS 1-35 · S/N 4Cancelled Aug 29, 2000 · Triennial form not returned · Peterson Nancy J N36WCWentworth BREEZY · S/N 550Cancelled Feb 23, 1994 · Triennial form not returned · Wen Worth Institute N4673KCessna R172K · S/N R1722007Cancelled Apr 17, 1991 · Triennial form not returned · Custance Robert W N30056Cessna 177 · S/N 177-010151Cancelled Jul 11, 1977 · Built 1968 · East Coast Aero Technical School N1947RRaven Vulcoon R S-50A · S/N S50A-153Cancelled Jul 2, 1977 · Built 1970 · Hall Ralph N15RHHall HOT AIR BALLOON AX6 · S/N 302Cancelled May 18, 1976 · Built 1974 · Hall Ralph H N848NSBeech 99 · S/N U-77Cancelled Jun 6, 1974 · Built 1969 · Chan-Air Inc N35ALBell 206B · S/N 821Cancelled Jun 26, 1973 · Pepsico Airlease Corporation N36ALBell 206B · S/N 826Cancelled Jun 26, 1973 · Built 1972 · Pepsico Airlease Corporation N351VBeech C-45H · S/N AF-295Cancelled Dec 9, 1971 · Pespsico Airlease Corporation N9043PPiper PA-24-260 · S/N 24-4506Cancelled Mar 22, 1971 · Air Industries Inc N9202HBoeing A75N1 · S/N 75-7584Cancelled Feb 24, 1971 · East Coast Aviation Corp N9214HBoeing A75L3 · S/N 757639Cancelled Feb 24, 1971 · East Coast Aviation Corp N84078Aeronca 7AC · S/N 7AC-2765Cancelled Feb 11, 1971 · East Coast Aviation Corp N3138EAeronca 7AC · S/N 7AC-6735Cancelled Jan 14, 1971 · East Coast Aviation Corp N4234NCessna 120 · S/N 13874Cancelled Jan 13, 1971 · East Coast Aviation Corp N69161Cessna T-50 · S/N 3781Cancelled Jun 22, 1970 · East Coast Aviation Corp N7334DPiper PA-22-150 · S/N 22-5123Cancelled Jun 9, 1960 · Exported to United Kingdom · East Coast Aviation Corp N4523APiper PA-22-150 · S/N 22-3830Cancelled Apr 15, 1960 · Exported to United Kingdom · East Coast Aviation Corp N2838ACessna 180 · S/N 30038Cancelled Oct 21, 1958 · Exported to Colombia · W E Howell Associates Inc N72179Cessna 140 · S/N 9348Cancelled Aug 7, 1957 · Exported to Canada · East Coast Aviation Corp N4078VCessna 170 · S/N 18410Cancelled Jun 17, 1957 · East Coast Aviation Corp N84642Aeronca 7AC · S/N 7AC-3359Cancelled Oct 12, 1955 · East Coast Aviation Corp N8911KStinson 108-1 · S/N 108-1911Cancelled Oct 4, 1955 · East Coast Aviation Corp N8490KStinson 108-1 · S/N 108-1490Cancelled Jan 7, 1954 · East Coast Aviation Corp N1487NPiper J-3C · S/N 23013Cancelled Oct 7, 1953 · Built 1947 · East Coast Aviation Corp N8143HHiller UH-12 · S/N 143Cancelled Jul 28, 1953 · Exported to United Kingdom · East Coast Aviation Corp N2742EAeronca 7AC · S/N 7AC-6323Cancelled Oct 3, 1952 · East Coast Aviation Corp N9487KStinson 108-3 · S/N 108-2487Cancelled Jun 16, 1949 · Fred A Valente And Richmond Gale

Back to Lexington, MA