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.
N3917EGray MXII · S/N 1191N4432VSaab A32 LANSEN · S/N 32284N58REKelly Michael K RALLY 3A · S/N 25034N7987PPiper PA-24-250 · S/N 24-3225N9283TPiper PA-38-112 · S/N 38-78A0318N8611SCessna 150F · S/N 15061911N86689Hiller UH-12L4 · S/N 2548N772WBeech C-45H · S/N AF-743N7748Schoenau WALT'S WING S-1 · S/N 1N7534XCessna 172B · S/N 17248034N7251CLockheed PV-2 · S/N 37550N5468XSaab A32 LANSEN · S/N 32209N64954Cessna 152 · S/N 15281498N64142Cessna 172M · S/N 17265044N6800QBeech 65-80 · S/N LD-31N5517BCessna 182 · S/N 33517N5521GCessna 150J · S/N 15071021N62031Bell 47J-2A · S/N 3716N75FROrion Distributing IV P · S/N LIV-348FBN8877MBeech A23 · S/N M-620N8360EMooney M20A · S/N 1538N7348Geser-Mcconnell BRIEGLEB BG-12BD · S/N 12076N6452YPiper PA-23-250 · S/N 27-3743N6791JPiper PA-28-140 · S/N 28-24519N2346GPiper PA-38-112 · S/N 38-79A0502N57219Boeing A75N1(PT17) · S/N 75-3073N1230HAeronca 15AC · S/N 15AC242N4651XCessna 150G · S/N 15064701N9393KStinson 108-2 · S/N 108-2393N7088KLet BLANIK L-13 · S/N 173422N7088RLet BLANIK L-13 · S/N 173717N7088ULet BLANIK L-13 · S/N 173718N7088ZLet BLANIK L-13 · S/N 174107N1693SSnow 600-S2C · S/N 600-1275CN102SPHiller OH-23G · S/N 64-15209N14FLRaven S55A · S/N S55A-339N540EPiper PA-23-250 · S/N 27-7N2647XCessna 206 · S/N P206-0147N3069PPiper PA-23-150 · S/N 23-987N66976Cessna T-50 · S/N 2935N5637QMooney M20C · S/N 3017N5542XAero Commander S2R · S/N 1742RN535ABellanca 14-19 · S/N 2088N707TBBeech 65-A80 · S/N LD-169N2466DPiper PA-38-112 · S/N 38-79A0324N400TACessna 411 · S/N 411-0064N2572NPiper PA-38-112 · S/N 3879A0925N40521Balloon Works FIREFLY 7 · S/N 10079N4401XPiper PA-28-151 · S/N 28-7615007N759YJCessna 182Q · S/N 18266362
Back to Fresno, CA