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 = 'NJ' AND d.registrant_city = 'PRINCETON' 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 = 'NJ' AND d.registrant_city = 'PRINCETON'
  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 = 'NJ' AND d.registrant_city = 'PRINCETON'
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.

N433FPPerkins Timothy STARLITE · S/N 137Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Perkins Timothy N383EESensefly EBEE AG · S/N EB-03-17542Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Princeton University N7320DBeech 60 · S/N P-95Cancelled May 27, 2022 · Exported to Honduras · United Trading Unlimted LLC N616ABCirrus Design SR22 · S/N 3616Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2010 · Ardnamara Aviation LLC N356ABKolb KOLB MARK III · S/N M3-008Cancelled Nov 20, 2020 · Sale reported, canceled · Built 1990 N201EHSensefly EBEE · S/N EB-03-23846Cancelled Dec 6, 2019 · Princeton University N67922Cessna 152 · S/N 15282100Cancelled Oct 25, 2019 · Exported to Canada · Built 1978 · Raritan Valley Flying School N378ESCessna 182S · S/N 18280013Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1997 · Ordowich Richard N93520Engineering & Research ERCOUPE 415-C · S/N 843Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Green Hornes Flying Club N2627Aereon AEROBODY MODEL 26 · S/N 001Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1969 · Aereon Corp N54020Cessna 172P · S/N 17274848Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1981 · Raritan Valley Flying School N5404KCessna 172P · S/N 17274096Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1980 · Raritan Valley Flying School N82PUBalloon Works FIREFLY 7 · S/N 11183Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1982 · Princeton Balloon Club Inc N2417WSchweizer SGU 2-22E · S/N 255Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1967 · Soaring Society Of Princeton Univ N7022MHoebel Bart AX 6 · S/N 2Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1996 · Bartley G Hoebel N94RPRobinson Helicopter R22 BETA · S/N 2422Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1994 N8ZZZielke Charles S RV-4 · S/N 3407Cancelled Jul 30, 2013 · Sale reported, canceled · Built 1994 N90598Let BLANIK L-13 · S/N 025518Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1973 · Karen Guth Inc N6310QMooney M20F · S/N 670403Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1967 · Millstone Aviation Inc N1128RRaven S55A · S/N S55A-310Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1976 · Hoebel Bartley G N96811Cessna 172P · S/N 17276118Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1984 N60753Cessna 150J · S/N 15070548Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1969 N83509Robinson Helicopter R22 BETA · S/N 3269Cancelled Feb 7, 2013 · First renewal notice · Built 2001 · Nassau Helicopters Inc N6103QCessna 152 · S/N 15285128Cancelled Oct 11, 2012 · Exported to Brazil · Built 1981 · Raritan Valley Flying School N2397HBalloon Works FIREFLY 7 · S/N 7722Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1978 · Hot Air Affair Inc N1919RRaven S55A · S/N S55A-398Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1978 · Hot Air Affair Inc N2116WBeech C23 · S/N M-1481Cancelled Aug 9, 2012 · Sale reported, canceled · Built 1973 N44RMBell Helicopter Textron Canada 206B · S/N 3130Cancelled Nov 28, 2007 · Exported to Canada · Built 1980 · Analar Corp N65509Cessna 152 · S/N 15281595Cancelled Jun 19, 2007 · Triennial form not returned · Built 1978 · Raritan Valley Flying School N2521HSocata TB-20 TRINIDAD · S/N 892Cancelled Mar 19, 2004 · Exported to Canada · Blinick Robert N47SSSchempp-Hirth STANDARD CIRRUS · S/N 281Cancelled Mar 3, 2003 · Built 1973 · Carlson John D N674RCRobinson Helicopter R44 · S/N 0712Cancelled Feb 21, 2003 · Exported to Canada · Built 2000 · Vtol Flight Ltd N54931Cessna 172P · S/N 17275081Cancelled Mar 21, 2002 · Exported to Canada · Built 1981 N5703PPiper PA-24-180 · S/N 24-776Cancelled Jun 12, 2000 · Triennial form not returned · Haupt William T N71419Henderson T A/Lynch H CICIDA · S/N CIC001Cancelled Aug 14, 1996 · Triennial form not returned · Trustees Of Princeton University N55110Cessna 172P · S/N 17275112Cancelled Jul 13, 1995 · Triennial form not returned · Raritan Valley Flying School N2446XRobinson Helicopter R22 BETA · S/N 0576Cancelled Feb 6, 1995 · Triennial form not returned · Mid Jersey Helicopter Ltd Inc N5754JBell 206B · S/N 3119Cancelled Jan 24, 1995 · Exported to Germany · Analar Company N4644NCessna 402C · S/N 402C0007Cancelled Oct 26, 1993 · Exported to Kenya · Geotec Associates N704MVCessna 150M · S/N 15078728Cancelled Jan 24, 1992 · Triennial form not returned · Gallant Arthur F N529WHHehmann Willaim F VARIEZE · S/N 1864Cancelled Mar 19, 1991 · Exported to United Kingdom · Misti Vincent James N8481JCessna 150G · S/N 15066381Cancelled Dec 18, 1981 · Rabe Ausma N8079EPiper PA-28R-201 · S/N 28R7918263Cancelled Jan 15, 1980 · Exported to United Kingdom · Princeton Aviation Corp N1855RCessna A185F · S/N 18502570Cancelled Mar 31, 1976 · Exported to Pakistan · Princeton Aviation Corp N46648Cessna 172K · S/N 17257409Cancelled Jun 21, 1973 · Exported to Norway · Princeton Aviation Corporation N7081GCessna 172K · S/N 17258781Cancelled Jun 21, 1973 · Exported to Norway · Princeton Aviation Corp N18562Cessna 150L · S/N 15073943Cancelled May 29, 1973 · Princeton Aviation Corp N8366NBeech E33 · S/N CD-1161Cancelled Jun 18, 1970 · Built 1968 · Princeton Planning Corp Of America N601XStokes M. E. SF · S/N SW-4-1Cancelled Jun 17, 1970 · Trustees Of Princeton University N4556UCessna 150D · S/N 15060556Cancelled May 13, 1970 · Princeton Aviation Corp

Back to Princeton, NJ