Skip to content

Cancelled registrations · 414

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 = 'OK' AND d.registrant_city = 'NONE' 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 = 'OK' AND d.registrant_city = 'NONE'
  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 = 'OK' AND d.registrant_city = 'NONE'
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.

N655AXAscending Technologies ASCTEC HUMMINGBIRD · S/N 21066Cancelled Jun 14, 2017 · Exported to Austria N657ECAscending Technologies ASCTEC HUMMINGBIRD · S/N 21059Cancelled Jun 14, 2017 · Exported to Austria N657FCAscending Technologies ASCTEC HUMMINGBIRD · S/N 21057Cancelled Jun 14, 2017 · Exported to Austria N657NXAscending Technologies ASCTEC HUMMINGBIRD · S/N 21077Cancelled Jun 14, 2017 · Exported to Austria N658ECAscending Technologies ASCTEC HUMMINGBIRD · S/N 20854Cancelled Jun 14, 2017 · Exported to Austria N658GCAscending Technologies ASCTEC HUMMINGBIRD · S/N 20917Cancelled Jun 14, 2017 · Exported to Austria N658QCAscending Technologies ASCTEC HUMMINGBIRD · S/N 20905Cancelled Jun 14, 2017 · Exported to Austria N658UCAscending Technologies ASCTEC HUMMINGBIRD · S/N 20575Cancelled Jun 14, 2017 · Exported to Austria N26RXAgusta A109C · S/N 7606Cancelled Jun 9, 2017 · Exported to Australia N597AAMcdonnell Douglas DC-9-83(MD-83) · S/N 53287Cancelled Jun 6, 2017 · Exported to Mexico · Built 1992 N66031Cessna T206H · S/N T20608512Cancelled Apr 4, 2017 · Exported to Mexico · Built 2005 N26TVBell 206B · S/N 4253Cancelled Mar 15, 2017 · Exported to New Zealand · Built 1992 N392BGSikorsky S-92A · S/N 920105Cancelled Dec 23, 2016 · Exported to Australia · Built 2009 N508CCBoeing 737-48E · S/N 25774Cancelled Dec 7, 2016 · Exported to Venezuela N5890HPiper PA-16 · S/N 16-511Cancelled Oct 18, 2016 · Exported to Brazil · Built 1949 N350EUPiper PA 46-350P · S/N 4636698Cancelled Sep 8, 2016 · Exported to Czech Republic N2578SCessna 337C · S/N 337-0878Cancelled Sep 6, 2016 · Exported to Russia · Built 1968 N908NRRaytheon HAWKER 800XP · S/N 258600Cancelled May 25, 2016 · Exported to Isle Of Man · Built 2002 N474MGulfstream Aerospace GIV-X (G450) · S/N 4073Cancelled May 17, 2016 · Exported to Saudi Arabia · Built 2007 N136USBell UH-1E · S/N 154777Cancelled May 12, 2016 · Exported to Norway N120MGBeech B100 · S/N BE-70Cancelled May 5, 2016 · Exported to Venezuela · Built 1979 N93BJCessna 421C · S/N 421C0014Cancelled Apr 19, 2016 · Exported to Venezuela · Built 1975 N31048Cessna 208B · S/N 208B5182Cancelled Dec 22, 2015 · Exported to Tanzania · Built 2015 N6218KDowner REPUBLIC RC-3 · S/N 421Cancelled Dec 9, 2015 · Exported to France · Built 1947 N1962FCessna 172N · S/N 17273052Cancelled Oct 5, 2015 · Exported to Philippines · Built 1979 N149JPEnstrom Helicopter 480B · S/N 5197Cancelled Jul 8, 2015 · Exported to Japan · Built 2014 N8738CPiper PA-22-135 · S/N 22-1387Cancelled May 14, 2015 · Sale reported, canceled · Built 1953 N321ZZChernus Steven CHRISTEN EAGLE II · S/N CHERNUS-0001Cancelled Apr 30, 2015 · Sale reported N7069YRobinson Helicopter R44 II · S/N 13768Cancelled Mar 12, 2015 · Exported to El Salvador · Built 2015 N79537Cessna 172K · S/N 17258158Cancelled Sep 29, 2014 · Sale reported, pending cancellation · Built 1969 N254PHawker Beechcraft C90GTI · S/N LJ-1901Cancelled Sep 11, 2014 · Exported to China · Built 2008 N109SPBeech A200 · S/N BC-42Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1978 N40778Smith SCORPIAN TOO · S/N 72924Cancelled Aug 28, 2014 · Sale reported, pending cancellation · Built 1974 N610DMMajor Danny C J450 · S/N 440Cancelled Jun 4, 2014 · Exported to Brazil · Built 2007 N5329UCessna U206G · S/N U20605210Cancelled May 8, 2014 · Exported to Kenya N739YJCessna 172N · S/N 17270910Cancelled Apr 8, 2014 · Exported to Brazil · Built 1978 N165WBoeing 737-247 · S/N 19605Cancelled Mar 27, 2014 · Sale reported · Built 1968 N2116XCessna 182T · S/N 18281318Cancelled Feb 27, 2014 · Exported to Guatemala · Built 2004 N35XPHarmon James B TALON XP · S/N H-1Cancelled Jan 14, 2014 · Exported to Mexico · Built 2001 N321PLPilatus PC-12/45 · S/N 321Cancelled Jan 9, 2014 · Exported to Canada · Built 2000 N1463QCessna T207A · S/N 20700783Cancelled Dec 24, 2013 · Exported to Mexico · Built 1984 N733AXCessna 172N · S/N 17268154Cancelled Dec 10, 2013 · Exported to Nigeria · Built 1976 N1837UCessna 172S · S/N 172S9923Cancelled Dec 5, 2013 · Exported to China · Built 2005 N198DECessna 340A · S/N 340A0918Cancelled Dec 5, 2013 · Exported to Mexico · Built 1980 N816CCIsrael Aircraft Industries GALAXY · S/N 020Cancelled Nov 15, 2013 · Exported to Canada · Built 2000 N6409HCessna 152 · S/N 15284165Cancelled Oct 28, 2013 · Exported to Brazil · Built 1979 N3328ZPiper PA-22-150 · S/N 22-7265Cancelled Sep 30, 2013 · Sale reported, canceled · Built 1960 N49445Cessna 152 · S/N 15283460Cancelled Sep 4, 2013 · Exported to Brazil · Built 1979 N202XPiper PA-28-160 · S/N 28-371Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1963 N5319GPiper PA-28-181 · S/N 2843436Cancelled Aug 23, 2013 · Exported to Germany

Back to None, OK