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.
N49858Cessna 152 · S/N 15281362N172KCessna 172M · S/N 17264011N25461Cessna C-145 · S/N 566N64262Cessna 172M · S/N 17265135N7188SRobinson Helicopter R22 BETA · S/N 3030N2806ZPiper PA-22-150 · S/N 22-6799N25422Cessna 152 · S/N 15280648N22454Cessna 150H · S/N 15068293N5160UCessna 172RG · S/N 172RG0266N1713Beech C-45H · S/N AF-643N873CKCessna 172S · S/N 172S9873N1302PPiper PA-23 · S/N 23-342N12353Cessna 172M · S/N 17261944N61736Cessna 172M · S/N 17264762N6131LCessna 152 · S/N 15284361N5080UCessna 206 · S/N 206-0080N9141YPiper PA-28-161 · S/N 28-8616014N2059CCessna 172P · S/N 17274407N80897Cessna 172M · S/N 17266794N152SCCessna 152 · S/N 15280265N757XSCessna 152 · S/N 15280091N59067Cessna 210L · S/N 21060066N1621XCessna 210L · S/N 21060657N393PTTodebush Peter C SH-2F · S/N 393FN111RFPiper PA-31T · S/N 31T-7520037N2327SRobinson Helicopter R22 BETA · S/N 2113N6471HCessna 152 · S/N 15284169N65552Cessna 152 · S/N 15281614N757VXCessna 152 · S/N 15280048N70144Robinson Helicopter R44 · S/N 0362N2566WRobinson Helicopter R22 BETA · S/N 0616N51215Cessna 172P · S/N 17274281N220SARaytheon 58 · S/N TH-2003N60665Cirrus Design SR22 · S/N 1275N60182Cirrus Design SR20 · S/N 1490N61036Cirrus Design SR22 · S/N 1305N398CDCirrus Design SR22 · S/N 1274N54125Cirrus Design SR22 · S/N 1203N187CDCirrus Design SR22 · S/N 0927N692CDCirrus Design SR22 · S/N 1017N193CDCirrus Design SR22 · S/N 0928N628CDCirrus Design SR22 · S/N 0912N134KPiper PA-28-235 · S/N 28-7410091N5004RCirrus Design SR22 · S/N 0851N51239Cirrus Design SR22 · S/N 0849N53423Cirrus Design SR22 · S/N 0828N803KCCirrus Design SR22 · S/N 0807N5361XCirrus Design SR20 · S/N 1409N81239Cirrus Design SR20 · S/N 1392N80904Cirrus Design SR22 · S/N 0780
Back to Hayward, CA