Skip to content

Cancelled registrations · 59

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 = 'CA' AND d.registrant_city = 'NORTHRIDGE' 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 = 'CA' AND d.registrant_city = 'NORTHRIDGE'
  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 = 'CA' AND d.registrant_city = 'NORTHRIDGE'
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.

N305RACessna 177B · S/N 17702002Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1977 · Lipsett Robert C N862BMooney M20A · S/N 1023Cancelled Jan 16, 2021 · Revoked, canceled · Built 1956 · Clarke Roger N9322H B Wilcox B-8-M · S/N 1Cancelled Jan 14, 2019 · Revoked, canceled · Built 1967 · Wilcox Harold B N4485KRyan NAVION · S/N NAV-4-1485Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1948 · Jackson Thomas M N57285Consolidated Vultee BT-13B (SNV-2) · S/N 79594Cancelled Apr 5, 2018 · Revoked, canceled · Snow Eugene F N8434SCessna 182H · S/N 18256534Cancelled Mar 16, 2018 · Revoked, canceled · Built 1965 · Plasschaert Alex E N86115Aeronca 11AC · S/N 11AC-546Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1946 · Neglio Gerard J N4895FCessna TU206A · S/N U206-0595Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1966 · Jet Set Aircraft Inc N82793Piper PA-32R-301T · S/N 32R-8129001Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1980 · Van Bastelaar Alphons N2038TSchweizer SGS 2-33A · S/N 493Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1977 · Kennard James B N4936DCessna 172N · S/N 17272405Cancelled Apr 30, 2015 · Built 1979 · Rhodes John D N7174LGrumman American Avn. AA-1B · S/N AA1B-0454Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1974 · Newman Christine N182AUCessna 182P · S/N 18262294Cancelled Dec 12, 2014 · Third renewal notice · Built 1973 · Jet Set Aircraft Inc N78107Globe GC-1B · S/N 2107Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1946 · Judson Marc J N4723JCessna 172N · S/N 17273669Cancelled Oct 20, 2014 · Registration expired, pending cancellation · Built 1979 · Jet Set Aircraft Inc N66JNorth American AT-6F · S/N 44-82028Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1945 · Leasure William E N18659Cessna 150L · S/N 15074021Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1972 · Judson Marc J N633TBeech J35 · S/N D-5351Cancelled Aug 6, 2013 · Revoked, canceled · Built 1957 · Neeser Thomas E N68703Fairchild M-62A-4 · S/N T43-4492Cancelled Jul 29, 2013 · Revoked, pending cancellation · Built 1947 · Eyster Eugene R Jr Co Ow N140CGCessna 140 · S/N 10305Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1946 N58136Mooney M20J · S/N 24-1568Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1985 · Stacey Ronald L N833YLord-Hall CHEROKEE II · S/N L-002Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1968 · Scheuerman Charles B N79366Mooney M20E · S/N 576Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1965 · Schultz Dale W N9202GCessna TU206G · S/N U20603811Cancelled Mar 29, 2013 · Exported to Mexico · Built 1977 · Jet Set Aircraft Inc N103RHMil MI-8MTB-1 · S/N 95722Cancelled Jun 28, 2012 · Built 1991 · Luke & Kristi LLC N5272HCessna 152 · S/N 15284077Cancelled Feb 13, 2007 · Triennial form not returned · Built 1979 · Sun Quest Inc N29KGRockwell International 690B · S/N 11548Cancelled Jun 1, 2006 · Exported to Mexico · Built 1979 · Jet Set Aircraft Inc N777JBeech C90A · S/N LJ-1163Cancelled Nov 18, 2002 · Exported to Dominican Republic · Built 1987 · Jet Set Aircraft N8307UPiper PA-34-220T · S/N 34-8333026Cancelled Jul 21, 2000 · Exported to Malaysia · Jet Set Aircraft Inc N5340XCessna TU206G · S/N U20605658Cancelled Apr 12, 2000 · Exported to Mexico · Jet Set Aircraft Inc N6654APiper PA-34-200 · S/N 347670138Cancelled Dec 1, 1998 · Jet Set Aircraft N25239Cessna 152 · S/N 15280547Cancelled Aug 14, 1997 · Exported to Mexico · Jet Set Aircraft Inc N13GWIsrael Aircraft Industries 1123 · S/N 162Cancelled Mar 24, 1995 · Exported to Colombia · Jet Set Aircraft N269JBBeech E-90 · S/N LW259Cancelled Aug 25, 1994 · Exported to Argentina · Jet Set Aircraft Inc N6606ZCessna U206G · S/N U20606339Cancelled Jun 17, 1994 · Exported to Mexico · Jet Set Aircraft N977STSill/Thomas LONG-EZ · S/N 100STCancelled Mar 16, 1994 · Triennial form not returned · Thomas Arthur N Jr N6432GCessna 150K · S/N 15071932Cancelled Jan 20, 1994 · Triennial form not returned · Hurt Roger A N3485FCessna 182J · S/N 18257485Cancelled Oct 21, 1993 · Triennial form not returned · Walker Robert A Jr N3311Cherokee II · S/N 0001Cancelled Aug 4, 1993 · Triennial form not returned · Fougner Kenneth L N313JLCessna 421B · S/N 421B0611Cancelled Dec 12, 1991 · Exported to Mexico N13VDHawks Virgil D QUICKIE · S/N 554Cancelled Feb 19, 1991 · Triennial form not returned · Hawks Virgil D N757TFCessna 152 · S/N 15279986Cancelled Apr 28, 1986 · Sikorski Joseph J N6323XBell Kitz Kopters 47D1 · S/N T-558Cancelled Oct 18, 1983 · George Lam E N95755Cessna 182Q · S/N 18266620Cancelled May 25, 1983 · Administratively canceled · Lee Han Joo N92063Cessna 182M · S/N 18260028Cancelled Dec 18, 1981 · Pincetich Vincent J N2670QCessna 182K · S/N 18257870Cancelled May 5, 1981 · Built 1967 · Anglea Ralphm Et Al N1963JAero Commander 500-B · S/N 500B-1277-108Cancelled Feb 23, 1981 · Built 1963 · Golden Triangle Ventures Inc N5818UPiper PA-28-140 · S/N 28-26648Cancelled Jul 12, 1977 · Van Kesteren Glen Richard N7242QCessna 172L · S/N 17260542Cancelled Nov 21, 1974 · Exported to Canada · Hirst Roger E N1240TPiper PA-28-140 · S/N 28-7225432Cancelled Apr 22, 1974 · Built 1972 · Welch Robert A

Back to Northridge, CA