Skip to content

Cancelled registrations · 40

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 = 'FAIRFIELD' 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 = 'FAIRFIELD'
  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 = 'FAIRFIELD'
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.

N860GOlsen Gordon L SNS-7 HYPERBIPE · S/N 8123Cancelled Nov 7, 2024 · Built 1986 · Irish Harley K N2284VCessna 140 · S/N 14514Cancelled May 25, 2022 · Exported to France · Built 1948 · Barnett Lance R N7532VCessna 177RG · S/N 177RG0829Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1976 · Thacker David C N3686Chernock THORP T-18 · S/N MMCVACCancelled Mar 13, 2020 · Sale reported, canceled · Built 1972 N612BMDJI INSPIRE 1 PRO · S/N W21ADA11021906Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Wheeless William Jared N86998Engineering & Research ERCOUPE 415-C · S/N 171Cancelled Sep 6, 2019 · Revoked, canceled · Built 1945 · Benson John D N359AWDJI S900 · S/N 0370062081Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Wheeless William J N3605DCessna 310 · S/N 35305Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 1956 · Solano Community College N7925ECessna 150 · S/N 17725Cancelled May 31, 2018 · Sale reported, canceled · Built 1959 N6811VAerostar Acft Corp Of Texas M20F · S/N 22-0003Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1971 · Tamayama Mitsuo N6108RCessna T210F · S/N T210-0008Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1965 · Chavez Gabriel G N4447GSix Chuter SKYE RYDER AEROCHUTE · S/N 96-1374-2Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Leiva Alexis M N248DWWaltermire Richard D GLASTAR · S/N 5571Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 2003 · Waltermire Richard D N7488ECessna 210 · S/N 57188Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1960 · Solano Community College N129ECCessna T182T · S/N T18208460Cancelled Aug 21, 2014 · Exported to South Africa · Built 2005 · Craig Dennis William N48055Cessna 152 · S/N 15283275Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1979 · Short Glenn O N91KFNiffenegger Ross KITFOX MOD IV 1200 · S/N 1823Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 2004 · Niffenegger Ross J N41067Piper J3C-65 · S/N 7693Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1941 N1139HAeronca 15AC · S/N 15AC-63Cancelled Sep 24, 2012 · Sale reported, pending cancellation · Built 1948 N2750ZSchweizer SGS 2-32 · S/N 2Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1964 · Mayes George R Md Inc N2293Gyrocopter B-8MEJ · S/N 90305Cancelled Aug 13, 2012 · Sale reported, canceled · Built 1971 N8670Schempp-Hirth STANDARD CIRRUS · S/N 47Cancelled Jun 26, 2012 · Exported to Argentina · Built 1970 · Demos David M N737ZQCessna 172N · S/N 17269805Cancelled Mar 17, 2009 · Exported to India · Built 1974 · Loomba Mukand Lal N31SHDerosier Sean DR-107 · S/N 273Cancelled Dec 9, 2008 · Triennial form not returned · Built 1999 · Derosier Sean P N620BDBoeing PT-13D · S/N 75-5620Cancelled May 29, 2008 · Exported to Australia · Built 1944 · Dekker William R Trustee N9949YCessna 210 · S/N 21064646Cancelled Apr 9, 2008 · Triennial form not returned · Beutner Karl N792GAGrumman American Avn. GA-7 · S/N GA7-0081Cancelled May 24, 2006 · Triennial form not returned · Cavanagh John F N212SFocke Wulf 44J STIEGLITZ · S/N 2924Cancelled May 5, 2004 · Exported to Germany · Built 1936 · Dekker William R Trustee N248DWWaltermire Richard D SA300 · S/N 13Cancelled Dec 28, 2000 · Exported to South Africa · Waltermire Richard D N103CRideout Don CAVALIER 102.5 · S/N 1Cancelled Sep 15, 2000 · Triennial form not returned · Rideout Don F N56877Piper PA-28R-200 · S/N 28R-7435055Cancelled Jul 17, 2000 · Triennial form not returned · Reid Robert W N1809YCessna 172C · S/N 17249409Cancelled Feb 25, 1994 · Exported to Honduras · La Buda David E N5475VBeech T-34A · S/N 534157Cancelled Feb 5, 1974 · United States Air Force N5116ZPiper PA-22-108 · S/N 22-8757Cancelled Jun 8, 1964 · Exported to Canada · Manuel Earl H N68711Cessna T-50 · S/N 4344Cancelled Apr 26, 1960 · Waite D Albert N2856DPiper PA-18 · S/N 18-876Cancelled Jul 11, 1957 · United States Air Force N5282KRyan NAVION B · S/N NAV-4-2182BCancelled Jan 29, 1953 · Wagner John N48800Fairchild PT-19A · S/N 301Cancelled Aug 17, 1950 · Waite Albert D N4329KRyan NAVION · S/N 1329Cancelled Mar 15, 1950 · Exported to Venezuela · Rossi R Felix Jr N34345Meyers OTW-160 · S/N 90Cancelled Nov 24, 1948 · Doyle P H

Back to Fairfield, CA