Skip to content

Cancelled registrations · 68

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

N893EADehavilland DHC-8-106 · S/N 241Cancelled Feb 13, 2024 · Exported to Canada · Built 1990 · Float Alaska Holdings LLC N5214CCessna T210N · S/N 21063718Cancelled Dec 10, 2022 · Sale reported, canceled · Built 1979 N8605ZPowrachute PEGASUS · S/N A275PEGCancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2004 · Drew Darrell E N523XLLiberty Aerospace LIBERTY XL-2 · S/N 0019Cancelled May 23, 2022 · Exported to Canada · Built 2006 · Fly Quest Aviation LLC N2137BLuscombe 8F · S/N 6564Cancelled Oct 25, 2019 · Revoked, canceled · Built 1949 · Hall Gordon E Co Ow N8881UCessna 172F · S/N 17252799Cancelled Jun 20, 2017 · Registration expired, pending cancellation · Built 1965 · Blue Diamond Aviation N6909LCessna 310K · S/N 310K0009Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1965 · Lightning Aircraft Corp N5961JCessna 172N · S/N 17273847Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Lightning Aircraft Corp N22798Cessna 150H · S/N 15068523Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1968 · Woldridge Johnny A N6361RPiper PA-28-140 · S/N 28-21532Cancelled Feb 4, 2017 · Revoked, canceled · Built 1966 · Shaw Daro E N98593Hughes OH-6A · S/N 67-16593Cancelled Sep 7, 2016 · Third renewal notice · Pomona Police Department N7318VBellanca 17-30 · S/N 30173Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1968 · Mcdaniel William D N109PMPiper PA-28-140 · S/N 28-23324Cancelled Mar 16, 2015 · Registration pending, canceled · Built 1967 N77000Hughes OH-6A · S/N 67-16000Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Pomona Police Department N4083KBensen B-8 STYIAS · S/N AS-1Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1964 · Styias A N9020LHughes 269A · S/N 65-18253Cancelled Aug 23, 2013 · Sale reported, canceled N3116HErcoupe 415-C · S/N 3741Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1946 N187LHLacey M10C · S/N 2Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1968 N4020AAyres S2R-R1340 · S/N R1340-002DCCancelled May 31, 2013 · Exported to Philippines N5624UPiper PA-28-140 · S/N 28-26420Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1969 · Salvato Orlando G N5975FCessna 210H · S/N 21058975Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1968 · Mehdy Sellam N5345PPiper PA-24-250 · S/N 24-390Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1958 · Pomona Dental Group N6853SAero Commander 680 · S/N 680-367-53Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1956 N4512ZPiper PA-28-161 · S/N 28-8016020Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1979 · Lapin Ari David N53367Cessna T-50 · S/N 4630Cancelled Aug 14, 2012 · Revoked, canceled · Built 1943 · Howard E D N2285ECessna 172N · S/N 17271220Cancelled Dec 28, 2011 · Exported to Argentina · Built 1978 · Lightning Aircraft Corp N8989UCessna 150M · S/N 15078039Cancelled Dec 28, 2011 · Exported to Argentina · Built 1976 · Lightning Aircraft Corp N9187GCessna 182P · S/N 18263383Cancelled May 3, 2011 · First renewal notice · Built 1974 · Lightning Aircraft Corp N2292NCessna 140 · S/N 12532Cancelled Jul 13, 2009 · Registration revoked · Built 1947 · Freeburn James H N4252PPiper PA-23-160 · S/N 23-1751Cancelled Jun 15, 2006 · Built 1959 · Charter Jet Inc N5107NBoeing B75N1 · S/N 75-7166Cancelled Feb 6, 2006 · Triennial form not returned · Built 1943 · Farhat Anthony F N6248YPiper PA-23-250 · S/N 27-3485Cancelled Mar 25, 1977 · Exported to Venezuela · Bonilla Kenneth Dr N2614PPiper PA-22-150 · S/N 22-2949Cancelled Apr 23, 1976 · Built 1955 · Henson Kenneth L & Santee Edwin E N1504PPiper PA-22-135 · S/N 22-2368Cancelled Sep 26, 1975 · Built 1954 · Egelhoff David A N3011MPiper PA-12 · S/N 12-1710Cancelled Jun 11, 1975 · Built 1947 · Anderson Clifford V N4680PPiper PA-23-250 · S/N 27-209Cancelled Sep 6, 1974 · Van Wagner James H N52092Stinson VULTEE V-77 · S/N 77-325Cancelled Nov 15, 1972 · Walker Arthur D N597NVickers/Supermarine SPITFIRE VB · S/N BM597Cancelled Nov 15, 1972 · American Aerospace & Military Museumn N976LAvro LANCASTER 10AR · S/N KB-976Cancelled Nov 15, 1972 · America Aerospace & Military Museum Inc N152AHansen TAILWIND W8 · S/N WH-1Cancelled Feb 23, 1972 · George J Gruenberger N99CCRoche BD-4 · S/N 168Cancelled Jul 16, 1971 · Roche Francis J N90135Cessna 140 · S/N 9196Cancelled Feb 24, 1971 · Glowacki Robert M N93875Ercoupe 415-C · S/N 1198Cancelled Sep 8, 1970 · Built 1946 · Dynair Club Inc N87127Ercoupe 415-C · S/N 300Cancelled Aug 20, 1970 · Exported to Canada · Built 1946 · Pedersen A D N9783WPiper PA-28-140 · S/N 28-23272Cancelled Jul 27, 1970 · Built 1967 · Thompson Bobbie B/Thompson Dixie B N5791KBeech S35 · S/N D-7566Cancelled Jun 23, 1970 · Mcgee Electric Inc N98WBensen B-8M · S/N 100Cancelled Jun 19, 1970 · Woodbridge L B N6081QMooney M20E · S/N 906Cancelled Aug 22, 1968 · Dynair Club Inc N52303Fairchild M-62A · S/N T41662Cancelled Nov 9, 1967 · Stewart Larry James N95832Taylorcraft BC12-D · S/N 8132Cancelled May 24, 1965 · Burt Robert F

Back to Pomona, CA