Skip to content

Cancelled registrations · 93

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 = 'CO' AND d.registrant_city = 'ERIE' 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 = 'CO' AND d.registrant_city = 'ERIE'
  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 = 'CO' AND d.registrant_city = 'ERIE'
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.

N20679Preceptor N-3 PUP · S/N 001Cancelled Nov 10, 2023 · Built 1993 · Hughes Michael D N3260VBeech 35 · S/N D-707Cancelled May 24, 2023 · Built 1947 · Cahoon Theodore J N7861KSchweizer 269C · S/N S1422Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Kinzie Industries Inc N411URoks Aero Progress T-411 · S/N 01Cancelled May 9, 2022 · Registration expired, pending cancellation · Andreatta David L N287BMCampbell John MUSTANG II · S/N 287Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2003 · Campbell John D N4508PPiper PA-23-250 · S/N 27-11Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1960 · Act Systems Inc N754YWDJI PHANTOM 3 ADVANCED · S/N P76DCL158B26365Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Wilde Matthew G N2536KHunter Stephen W AX-6 · S/N 003Cancelled Feb 12, 2019 · Built 2003 · Hunter Distributing LLC N117BEGreene R/Greene S RANS S-17 · S/N 1202040Cancelled May 30, 2018 · Sale reported, canceled N409LHEnstrom 280FX · S/N 2014Cancelled May 30, 2018 · Sale reported, canceled · Built 1987 N1452Airbus Industrie A300 B4-203 · S/N 093Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Pacific Aeromotive Corp N268STHughes Helicopters HUGHES 369D · S/N 470122DCancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1977 · Pacific Aeromotive Corp N2420RCessna 182G · S/N 18255520Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1964 · Pacific Aeromotive Corporation N228LLPiper PA 46-350P · S/N 4622164Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1994 · Real Estate School LLC N5733NBell 206B · S/N 3009Cancelled Mar 5, 2018 · Registration expired, pending cancellation · X Cell Aero Inc N58163Hughes 269C · S/N 740334Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1974 · Kinzie Industries Inc N68705Cessna 152 · S/N 15282324Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1978 · Xcell Aero Inc N54LCSchweizer 269C · S/N S1581Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1991 · Pacific Aeromotive Corp N7862KSchweizer 269C-1 · S/N 0009Cancelled Feb 15, 2018 · Sale reported, canceled N9643FHughes 269C · S/N 1200076Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1972 N13TCStarduster S.A.100 · S/N 2Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1974 · Haselwood James T N9645ABell UH-1B · S/N 303Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Pacific Aeromotive Corp N233MPRobinson Helicopter R44 · S/N 0619Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1999 · Pacific Aeromotive Corp N207ABCessna T207 · S/N 20700342Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1976 · Aero Systems Inc N209LHSchweizer 269C · S/N S1881Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Pacific Aeromotive Corporation N61480Schweizer 269C · S/N S1765Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1998 · Pacific Aeromotive Corp N46ALBell 206B · S/N 963Cancelled Oct 24, 2017 · Registration expired, pending cancellation · X-Cell Aero Inc N968YCBell 206B · S/N 1427Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Pacific Aeromotive Corp N896WBell UH-1B · S/N 62-4576Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1963 · Pacific Aeromotive Corp N8099ZBeech B36TC · S/N EA-516Cancelled Dec 1, 2016 · Exported to Mexico · Built 1991 · Ureno-Rivera Jose Reyes N1835ESchweizer 269C-1 · S/N 0255Cancelled Aug 11, 2016 · Expired dealer · Built 2006 · Kinzie Industries Inc N2056JSchweizer 269C · S/N S1820Cancelled Aug 11, 2016 · Expired dealer · Built 2001 · Kinzie Industries Inc N2196FSchweizer 269C · S/N S1647Cancelled Aug 11, 2016 · Expired dealer · Built 1994 · Kinzie Industries Inc N269HBSchweizer 269C-1 · S/N 0166Cancelled Aug 11, 2016 · Expired dealer · Built 2004 · Kinzie Industries Inc N381MCSchweizer HUGHES 269C · S/N S1240Cancelled Aug 11, 2016 · Expired dealer · Kinzie Industries Inc N61425Schweizer 269C-1 · S/N 0029Cancelled Aug 11, 2016 · Expired dealer · Built 1996 · Kinzie Industries Inc N90570Hughes 269C · S/N 1180736Cancelled Aug 11, 2016 · Expired dealer · Kinzie Industries Inc N9679FHughes 269C · S/N 310103Cancelled Aug 11, 2016 · Expired dealer · Built 1971 · Kinzie Industries Inc N428MSSchweizer 269C · S/N S1424Cancelled May 21, 2015 · Sale reported, canceled · Built 1989 N322MHSchweizer 269C · S/N S1786Cancelled May 11, 2015 · Sale reported, canceled · Built 1999 N2686WMooney M20C · S/N 3321Cancelled Jan 29, 2015 · Expired dealer · Built 1966 · Pacific Aeromotive Corp N9078TContinental Copters TOMCAT MK5A · S/N CCI-76-3Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1976 · Xcell Aero N4316VCessna 195 · S/N 7223Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1948 · Page Paul E DBA N189BLLarson Bill A LARSON AKROSTAR 330 · S/N 0001Cancelled Oct 7, 2014 · Exported to Spain · Built 1990 · Gordon Albert A N10867Bell Helicopter Textron 206L-1 · S/N 45443Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1980 · X Cell Aero Inc N3351RCessna 182L · S/N 18258651Cancelled Sep 8, 2014 · Exported to Mexico · Built 1967 · Perez Cesar Ureno N408RARemos REMOS G-3/600 · S/N 237Cancelled Nov 7, 2013 · Built 2008 · Skyraider Aviation Inc N320FRRothrock Donald R COZY MK IV MODIFIED · S/N ROTHROCK 001Cancelled Aug 23, 2013 · Sale reported, canceled · Built 2000 N2005VCessna 140 · S/N 14216Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1947 N461KSFaehmel Ryan PA-18 REPLICA · S/N TC0604105Cancelled Jun 7, 2013 · Exported to Canada · Built 2012 · K & S Aviation Inc

Back to Erie, CO