Hayward, CA
Cancelled registrations · 263
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 = 'HAYWARD' 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 = 'HAYWARD' 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.
N6342MCessna 152 · S/N 15284683N13336Cessna 172M · S/N 17262680N8078JPiper AEROSTAR 601P · S/N 61P05657963245N4930WRockwell International 114 · S/N 14253N3378ZPiper PA-18A 150 · S/N 18-7259N4112YBellanca 8KCAB · S/N 287-77N46630Cessna 172K · S/N 17257395N6755TCessna 310D · S/N 39055N8361EMooney M20A · S/N 1539N6526SCessna 150H · S/N 15067326N2865GChampion 7ECA · S/N 513N60516Cessna 150J · S/N 15070366N36234Bellanca 7ECA · S/N 959-73N25722Beech 95-B55 · S/N TC-1613N22509Cessna 150H · S/N 15068326N3092DCessna 310 · S/N 35292N411UBeech D18S · S/N A122N60997Cessna 150J · S/N 15070722N22446Cessna 150 · S/N 15068289N2093PPiper PA-23 · S/N 23-681N11094Champion 7ECA · S/N 101N6204UMooney M20C · S/N 2043N3180SCessna 182 · S/N 18255680N3766JCessna 150G · S/N 150-65066N56703Aeronca 0-58B · S/N 12463N6972XCessna 172B · S/N 17247872N50926Cessna 150J · S/N 15069648N10411Beech C18S · S/N 66402N60313Cessna 150J · S/N 15070219N6408GCessna 150K · S/N 15071908N6368RPiper PA-28-140 · S/N 28-21540N5972QMooney M20E · S/N 846N54323Cessna T-50 · S/N 6457N99941Engineering & Research 415-C · S/N 2546N2657NCessna 120 · S/N 12915N5252YPiper PA-23-250 · S/N 27-2312N4351UCessna 150D · S/N 15060351N2424DCessna 170B · S/N 20576N68267Schweizer TG3A · S/N 16N72643Cessna 140 · S/N 9819N2994NCessna 140 · S/N 13252N1967NCessna 120 · S/N 12203N5895PPiper PA-24-250 · S/N 24-982N9613ACessna 140A · S/N 15476N2360PPiper PA-18 · S/N 18-4246N89815Cessna 140 · S/N 8864N3215DCessna 180 · S/N 32013N4391VCessna 195 · S/N 7342N1760NCessna 120 · S/N 12004N65989Howard GH-3 · S/N 949
Back to Hayward, CA