Skip to content

Cancelled registrations · 75

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 = 'PA' AND d.registrant_city = 'LANCASTER' 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 = 'PA' AND d.registrant_city = 'LANCASTER'
  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 = 'PA' AND d.registrant_city = 'LANCASTER'
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.

N7137QPowerchute PEGASUS · S/N A277 PEGCancelled Mar 7, 2026 · Sale reported, canceled · Built 2004 N4092DCessna 182A · S/N 34792Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1957 · G3 Productions LLC N799NADJI PHANTOM 4 · S/N 07DDD350B10153Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Peck Craig S N451TDCirrus Design SR22 · S/N 0064Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2001 · Cpd-Jjd LLC N49707Boeing A75N1(PT17) · S/N 754285Cancelled Nov 19, 2019 · Revoked, pending cancellation · Built 1942 · Crouse Paul C N8399EMooney M20A · S/N 1587Cancelled Sep 6, 2019 · Revoked, canceled · Built 1960 · Garden Spot Airpark Inc N592YPCraig Peck DJI FLAME WHEEL F550 · S/N 3681513Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Peck Craig S N590BPCraig S Peck AERONAVIES SKYJIB TI · S/N 8675309Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Peck Craig S N51725Fairchild M-62A · S/N T435868Cancelled May 18, 2018 · Revoked, canceled · Built 1943 · Lefever Clarence N8631BCessna 172 · S/N 36331Cancelled Mar 16, 2018 · Revoked, canceled · Built 1957 · Moyer Jr Theodore R N61034Cameron Balloons US A-140 · S/N 5526Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1989 · Plank Todd N N721GAGrumman American Avn. GA-7 · S/N GA7-0019Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 1978 · Davco Corp N6120JCameron Balloons US N-105 · S/N 5536Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1989 · Lancaster Balloons Inc N7282YPiper PA-30 · S/N 30-320Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Lancaster Photoengraving Co N8969LGrumman American Avn. AA-1B · S/N AA1B-0419Cancelled Dec 19, 2015 · Built 1974 · Rathmell John P N24596Piper J3L-65 · S/N 3284Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1939 · Trainer Robert W N8707EFaltin John R ROTORWAY EXEC 162F · S/N F6203Cancelled Feb 2, 2015 · First renewal notice · Built 2006 · Faltin John R N71USPiccard AX-6 · S/N 671Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1973 · Penn Dutch Real Estate Inc DBA N500LBCessna 340 · S/N 340-0006Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1971 · Davco Corp N9399LAmerican AA-1A · S/N AA1A-0099Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1971 · Price Andrew L N4440FPeris James E GOLDWING · S/N 059Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1982 · Peris James E N51772Enstrom F-28C · S/N 439Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1978 · Kuhn Michael N2493ZGeneral Balloon AX-6 · S/N 493Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1981 · Gemutlichkeit Air Inc N6536LGrumman American Avn. AA-1B · S/N AA1B-0336Cancelled Aug 7, 2013 · Revoked, canceled · Built 1973 · Heisey Mervin W N6377HPiper J3C-65 · S/N 19557Cancelled Aug 6, 2013 · Revoked, canceled · Built 1946 · Moyer Theodore R Jr N744CBCameron Balloons O-65 · S/N 732Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1982 N3480Bensen B-8M · S/N 8255243Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1968 N99419Ercoupe 415-D · S/N 2042Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1946 · Blackburn David A N6839TCessna 310D · S/N 39139Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1960 · Martin David S N926King BENSEN B-8M · S/N MBK19721Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1973 N2449ZGeneral Balloon AX-6 · S/N 449Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1979 · Hess Richard F N999GSSmoker Glen E ROTORWAY EXEC · S/N 32958Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1988 · Smoker Glen E N236CBCameron Balloons O-77 · S/N 640Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1982 · Penn Dutch Real Estate Incdba N193CRFurst Paul E RANS S-12 · S/N 1Cancelled Aug 9, 2012 · Registration pending, canceled N85JNPeris James E JN-1 · S/N 059Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Peris James E N999YKRaven S55A · S/N S55A-1076Cancelled May 18, 2012 · Registration expired, pending cancellation · Built 1985 · Plank Todd N N111DAero Commander 680 · S/N 680-460-130Cancelled Jul 7, 2011 · Expired dealer · Built 1956 · East Coast Aircraft Sales Inc N397BALet L 33 SOLO · S/N 020601Cancelled Jul 28, 2010 · Triennial form not returned · Built 2002 · Edgerton Byron D Jr N1529VWilliams Special LOW WING · S/N 1Cancelled Sep 18, 2009 · Registration revoked · Moyer Aviation Service N2799MPiper PA-12 · S/N 12-1406Cancelled Jul 20, 2009 · Registration revoked · Built 1946 · Moyer Theodore N9962FCessna 172R · S/N 17280196Cancelled Jan 23, 2007 · Triennial form not returned · Built 1997 · Engel Elvin R DBA N210JSCameron Balloons O-77 · S/N 482Cancelled Dec 7, 2006 · Triennial form not returned · Built 1979 · Penn Dutch Real Estate Inc DBA N7040BPiper PA-22-150 · S/N 22-4291Cancelled May 25, 2006 · Triennial form not returned · Built 1956 · Kerekgyarto Louis J Jr N9183YPiper PA-28-161 · S/N 28-8616016Cancelled Apr 26, 2006 · Built 1985 · Murphy Air LLC N290FSSherick Frederick H LANCAIR 235 · S/N 118Cancelled Aug 22, 2005 · Exported to Canada · Built 1991 · Sherick Frederick H N700MMPiper PA-60-602P · S/N 60-8265031Cancelled Oct 14, 2003 · Triennial form undeliverable · Built 1982 · Zero One Tango Inc N12067Cessna 172M · S/N 17261796Cancelled Sep 11, 2003 · Second triennial mailing, no response · Built 1973 · Central Manor Aviation Inc N5215QCessna 152 · S/N 15285086Cancelled Jun 4, 2003 · Exported to Canada · Airways Inc N270BBMooney M20M · S/N 27-0012Cancelled Apr 8, 2000 · Triennial form not returned · Walmer Marlin S DBA N7730JPiper PA-32-260 · S/N 32-1132Cancelled Apr 23, 1999 · Mitchell Steven M

Back to Lancaster, PA