Skip to content

Lexington Park, MD

Cancelled registrations · 25

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 = 'LEXINGTON PARK' 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 = 'LEXINGTON PARK'
  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 = 'LEXINGTON PARK'
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.

N1457BProgressive Aerodyne SEAREY LSA · S/N 1009Cancelled May 4, 2024 · Sale reported, canceled · Built 2014 N962CSTextron T206H · S/N T20609624Cancelled Jul 18, 2023 · Exported to Timor Leste · Built 2021 N798AXBoeing 767-200 · S/N 23431Cancelled Mar 17, 2021 · Sale reported · Built 1987 N34PRBeech D-45 (T-34B) · S/N BG-255(140921)Cancelled May 30, 2018 · Sale reported, canceled · Built 1956 N4744SSchleicher KA 6 CR · S/N 6368Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1965 N75220Quicksilver/Kelly SPORT II · S/N 1411Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Kelly James T N75233Kolb FIRESTAR · S/N 026Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Kelly James T N75238Solar Wings WINDLASS · S/N 726Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Kelly James T N95144Cessna 152 · S/N 15285857Cancelled Jul 21, 2017 · Registration expired, pending cancellation · Built 1984 · Whitehead Derek N25549Defense Technologies KESTREL-G · S/N 002Cancelled May 31, 2017 · Registration expired, pending cancellation · Defense Technologies Inc N2554BDefense Technologies KESTREL-T · S/N 001Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2008 · Defense Technologies Inc N2554VDefense Technologies KESTREL-T · S/N 003Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2006 · Defense Technologies Inc N2555ADefense Technologies KESTREL-E · S/N 001Cancelled May 31, 2017 · Registration expired, pending cancellation · Defense Technologies Inc N2555RDefense Technologies KESTREL-T · S/N 002Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2008 · Defense Technologies Inc N341JLL-3 Bai Aerosystems VIKING 300 · S/N 304Cancelled May 31, 2017 · Registration expired, pending cancellation · L-3 Services Inc N315TXLove David R RV-8 · S/N 82517Cancelled Oct 11, 2016 · Exported to United Kingdom · Built 2008 · Bergman Adam H N2775DDefense Technologies KESTREL-T · S/N 10Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Defense Technologies Inc N2785DDefense Technologies KESTREL-T · S/N 11Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Defense Technologies Inc N44TRAmerican AA-1A · S/N AA1A-0232Cancelled Jun 13, 2014 · Built 1971 · Kelly Mark D N4577KRyan NAVION · S/N NAV41577Cancelled Sep 20, 2012 · Revoked, canceled · Built 1948 · National Trailer Sales N61751Cessna T-50 · S/N 5348Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Kilstrom Eugene F N75356L-3 Bai Aerosystems VIKING 300 · S/N 303Cancelled Nov 9, 2010 · L-3 Services Inc (Lsi)N7400JPiper PA-28-140 · S/N 2824763Cancelled Sep 13, 1997 · Triennial form not returned · Mogge Gary A N3052EAeronca 7AC · S/N 6641Cancelled Aug 13, 1971 · Park Hall Flying Club Inc N125NTemco D-16A · S/N TTN-61Cancelled Apr 20, 1961 · Exported to Canada · Patuxent Motor Sales & Anchor Van Lines

Back to Lexington Park, MD