Fresno, CA
Cancelled registrations · 437
Query with SQL
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 = 'FRESNO' 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 = 'FRESNO' 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.
N2292WBell 206B · S/N 505N63457Boeing PT-17 · S/N 75-2149N911EWEurocopter AS 350 B2 · S/N 2657N530KDMcdonnell Douglas Heli 369FF · S/N 0044FFN505WWAerospatiale AS350 B2 ECUREUIL · S/N 2442N795DFBeech B200 · S/N BB-1510N408FCBell 407 · S/N 53450N7249WPiper PA-28-180 · S/N 28-1077N912KWAerospatiale AS350B2 · S/N 2260N176PAPetrus David Wayne S-90 · S/N 80842N3889FPiper PA-28-181 · S/N 28-7690455N8340GCessna 150F · S/N 15062440N2578LPiper PA-38-112 · S/N 38-79A0768N7409MCessna 175 · S/N 55709N5029ACessna 172 · S/N 28029N302FBFantasy Sky Promotions FANTASY EIGHT · S/N 049N8003PPiper PA-24-250 · S/N 24-3243N23415Piper PA-38-112 · S/N 38-81AOO99N701TUPicard Martin W ZENAIR CH701 · S/N 7-7208N62410Cessna 305A · S/N 23191N811QCorbus/Winters BD-5B · S/N 3239N9229UCessna 150M · S/N 15078179N89FLBeech 65 · S/N LC-95N8296Beech 65 · S/N LC-113N7270FCessna 182E · S/N 18254085N7070SCessna 150H · S/N 15067770N4746PPiper PA-23-250 · S/N 27-282N23628Taylorcraft BC-65 · S/N 1359N10828Cessna 150L · S/N 15075068N68855Beech C18S · S/N 7488N7414CLockheed PV-2 · S/N 151428N25092Piper PA-38-112 · S/N 38-80A0030N269BVSikorsky UH-34D · S/N 148816N67468Boeing A75 · S/N 75-7469N7773North American P-51C · S/N A68-1N5512XRockwell International S-2R · S/N 1712RN6434ECessna 172 · S/N 46534N80664Landry Allen E QUICKIE · S/N 197N7086CLockheed PV-2 · S/N 151410N6345RPiper PA-28-140 · S/N 28-21515N43378Taylorcraft BC12-D · S/N 7037N2408UCessna 172 · S/N 29566N9816KStinson 108-2 · S/N 108-2816N1726HCessna 310C · S/N 35826N3977WPiper PA-32-260 · S/N 32-944N418CStinson 108-2 · S/N 108-3418N2866UAerostar International RX-7 · S/N RX7-3010N4824VBellanca 17-30 · S/N 30093N31247Hvass BENSEN B8 GYROGLIDER · S/N BHG-1N49297Moore Marvin A TIERRA II · S/N VA002
Back to Fresno, CA