Fullerton, CA
Cancelled registrations · 246
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 = 'FULLERTON' 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 = 'FULLERTON' 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.
N6688GCessna 150L · S/N 15072188N8976HRyan NAVION · S/N NAV-4-976N3827UCessna 336 · S/N 336-0127N17278Piper PA-23-160 · S/N 23-1615N616RBBerg Reuben C SIROCCO SN 209 MJ5 · S/N 209N149BBMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-49N5541GCessna 150J · S/N 15071041N92BJDaley Joseph R SEAHAWKER · S/N 56N3930Morgan B8M · S/N 010N6376GCessna 150K · S/N 15071876N63393Stinson L-5 · S/N 1909N2729NCessna 120 · S/N 12987N365SXHein Richard A SONEX · S/N 365N3170VBeech 35 · S/N D-603N19034Cessna 150L · S/N 15074111N138VPPiper PA-28-140 · S/N 28-21135N14437Beech 3NM · S/N CA202N394MECessna 182S · S/N 18280869N4883JCessna 172N · S/N 17273690N4816GCessna 172N · S/N 17273364N46757Cessna 152 · S/N 15283100N5629QMooney M20C · S/N 3104N23517Robinson Helicopter R22 BETA · S/N 2231N3624HMooney M20K · S/N 250432N2419CPiper PA-38-112 · S/N 3879A0176N26775Gulfstream American AA-5A · S/N AA5A0710N29044Cessna U206C · S/N U2061030N8485BSlater Mark BENSEN B8M · S/N 43148553N48418Cessna 152 · S/N 15283337N33866Piper PA-34-200T · S/N 34-7570173N3971CCessna 402B · S/N 402B0843N2300TPiper PA-28-140 · S/N 28-7125478N51751Cessna 172P · S/N 17274343N39056Grumman American Avn. AA-1C · S/N AA1C0205N6049YPiper PA-23-250 (6PCLM) · S/N 27-3238N732ARCessna T210L · S/N 21061367N50RWWalter-Ronald VARI-EZE · S/N 52N11497Cessna 150L · S/N 15075462N33167Piper PA-28-140 · S/N 28-7525167N4599UCessna TU206G · S/N U20604992N70750Cessna A185E · S/N 185-01814N4WEPiper PA-31-350 · S/N 31-7552064N7025YPiper PA-30 · S/N 30-26N5391CCessna 210N · S/N 21063739N8553QCessna A185F · S/N 18503733N4932ECessna A185F · S/N 18503911N34825Cessna 177B · S/N 17702027N49451Cessna 152 · S/N 15281278N756KUCessna U206G · S/N U20604159N4776QCessna A185E · S/N 1851243
Back to Fullerton, CA