Skip to content

Cancelled registrations · 62

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 = 'VA' AND d.registrant_city = 'FAIRFAX' 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 = 'VA' AND d.registrant_city = 'FAIRFAX'
  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 = 'VA' AND d.registrant_city = 'FAIRFAX'
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.

N134PWAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0234Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2008 · Parks Keith N223JBMitsubishi MU-2B-36A · S/N 724SACancelled Jul 23, 2022 · Registration expired, pending cancellation · Built 1978 · Burton Air Corporation Inc N2000YCessna TU206C · S/N U206-1185Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1968 · Dzyne Technologies Inc N637GEDJI PHANTOM 3 PROFESSION · S/N CH270207352703Cancelled Apr 2, 2022 · Registration expired, pending cancellation · English William R N8454YPiper PA-32-301 · S/N 32-8206001Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1981 · Hubbell-Aero LLC N3951NMooney M-20G · S/N 680066Cancelled Jan 23, 2021 · Registration expired, pending cancellation · Built 1968 · Rowan Joseph D N571TWTextron 208B · S/N 208B5571Cancelled Jan 8, 2021 · Exported to United Arab Emirates · Built 2019 · Mag Ds Corp DBA N574TWTextron 208B · S/N 208B5574Cancelled Jan 8, 2021 · Exported to United Arab Emirates · Built 2019 · Mag Ds Corp DBA N570TWTextron 208B · S/N 208B5570Cancelled Dec 2, 2020 · Exported to United Arab Emirates · Built 2019 · Mag Ds Corp DBA N572TWTextron 208B · S/N 208B5572Cancelled Dec 2, 2020 · Exported to United Arab Emirates · Built 2019 · Mag Ds Corp DBA Mag Aerospace N84UAParrot AR DRONE 2.0 · S/N PS721000AC2Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Ryan James F N223KFDJI PHANTOM 2 VISION PLU · S/N PH645495277Cancelled Jan 3, 2020 · Registration expired, pending cancellation · Koo-Koo Productions LLC N564NE3drobotics QUAD 2013 · S/N R101107531Cancelled Jan 8, 2019 · Registration expired, pending cancellation · English William R N567GEDJI PHANTOM 2 VISION · S/N PH636054974Cancelled Jan 8, 2019 · Registration expired, pending cancellation · English William R N27KJStaudacher Jon S-600F · S/N 32Cancelled Oct 2, 2018 · Registration expired, pending cancellation · Built 2005 · Taylor David C N86656Helton LARK 95 · S/N 9505Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1966 · Ball Robert H N5122VMorrisey 2150A · S/N SP-18Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1961 · Ball Robert H N766RGDJI PHANTOM 3 PROFESSION · S/N P76DCK13A26162Cancelled Jan 9, 2018 · Lamond Robert G Jr N61954Cessna 172M · S/N 17264911Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1975 · Cross Flot Aviation Inc N94755Engineering & Research ERCOUPE 415-CD · S/N 4866Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Midkiff Wm J N1612UBevins SOPWITH PUP · S/N 1917Cancelled Oct 28, 2017 · Revoked, canceled · Anger Chas R N2156UBrantly B-2A · S/N 316Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1963 · Faircloth Roy N781MADiamond Aircraft Ind DA20-C1 · S/N C0281Cancelled Jan 31, 2017 · First renewal notice · Built 2004 · Rame Inc N6059NBeech 19A · S/N MB-383Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1968 · Braithwaite Michael N32511Jones Douglas E FLIGHTSTAR FORMULA · S/N 0137Cancelled May 6, 2015 · Registration expired, pending cancellation · Douglas Jones N8242RBellanca 17-31A · S/N 32-87Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1972 · Airways Transporation Inc N16710Embraer EMB-120ER · S/N 120.106Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Rodriguez Elias C Trustee N12709Embraer EMB-120ER · S/N 120.101Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1988 · Rodriguez Elias C Trustee N88SVSukhoi SU-29 · S/N 72-05Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Aeropractice Inc N4471KRyan NAVION A · S/N NAV-4-1471Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1948 · Harris Robert J N6232PPiper PA-24-250 · S/N 24-1336Cancelled Aug 5, 2013 · Revoked, canceled · Built 1959 · Edwards Ronald J N4095KPiper PA-31-350 · S/N 31-8152177Cancelled Mar 25, 2013 · Sale reported, canceled N770EZShniderman Ervin Stanley LONG-EZ · S/N 1276Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1985 N36YMonocoupe 110 SPECIAL · S/N 7W96Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1941 · Mcculloch John J N65679Cessna T-50 · S/N 2837Cancelled Sep 5, 2012 · Revoked, canceled · Built 1942 · Traylor Mahlon E Jr N4694FPiper PA-28-140 · S/N 28-7725027Cancelled Apr 26, 2012 · Built 1976 · Paul Craig R N5310Bensen B-8M · S/N HLZ5421Cancelled Feb 27, 2012 · Revoked, pending cancellation · Built 1968 · Hutchison Marbury M N131BWSukhoi SU-31 · S/N 0501Cancelled Nov 9, 2007 · Triennial form not returned · Built 1999 · Boriak Sergei A N501SARaytheon 58 · S/N TH-1853Cancelled Sep 12, 2007 · Exported to Australia · Built 1998 · Bay Hill Baron LLC N7152RPiper PA-28-140 · S/N 28-21859Cancelled Feb 2, 2006 · Built 1966 · Infosolv LLC N475FWilliams Bill VANS RV-4 · S/N BWS4Cancelled Dec 29, 2003 · Built 1991 · Gonzalez Jorge E N16719Embraer EMB-120ER · S/N 120.138Cancelled Jan 14, 2000 · Exported to Brazil · Rodriguez Elias C Trustee N31711Embraer EMB-120ER · S/N 120.107Cancelled Jan 14, 2000 · Exported to Brazil · Rodriguez Elias C Trustee N12705Embraer EMB-120ER · S/N 120.089Cancelled Jul 23, 1999 · Exported to Uruguay · Rodriguez Elias C Trustee N579CDJanning Donald J TORNADO II · S/N D97582SOHK0258Cancelled Jul 12, 1999 · Janning Donald J N18080Beech C90 · S/N LJ972Cancelled Aug 3, 1995 · Exported to Switzerland N125RJJarmon Roger M JARMON-GLASAIR · S/N 125Cancelled Feb 3, 1995 · Triennial form not returned · Jarmon Roger M N82936Beech 1900D · S/N UE77Cancelled Feb 25, 1994 · Exported to Nigeria · Mobil Producing Negeria Ultd N3647TPiper AEROSTAR 602P · S/N 62P08658165005Cancelled Mar 3, 1993 · Potomac Imaging Associates P C N8664PPiper PA-24-260 · S/N 244111Cancelled May 23, 1991 · Lee Phillip A

Back to Fairfax, VA