Goodyear, AZ
Registered aircraft · 180
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'AZ' AND g.registrant_city = 'GOODYEAR' ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'AZ' AND g.registrant_city = 'GOODYEAR' ORDER BY g.n_number
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.
N455AVCirrus Design SR20 · S/N 8954N46186Aeronca 0-58B · S/N 12103N466AVCirrus Design SR20 · S/N 8959N468AVCirrus Design SR20 · S/N 9083N4691GCessna 172N · S/N 17273317N469AVCirrus Design SR20 · S/N 9084N470AVCirrus Design SR20 · S/N 9085N471AVCirrus Design SR20 · S/N 9086N473AVCirrus Design SR20 · S/N 9095N474AVCirrus Design SR20 · S/N 9100N475AVCirrus Design SR20 · S/N 9118N476AVCirrus Design SR20 · S/N 9128N478AVCirrus Design SR20 · S/N 9175N479AVCirrus Design SR20 · S/N 9180N483AVCirrus Design SR20 · S/N 9325N48530Aeronca 0-58B · S/N 0-58B-3182N485AVCirrus Design SR20 · S/N 9311N486AVCirrus Design SR20 · S/N 9315N488AVCirrus Design SR20 · S/N 9305N489AVCirrus Design SR20 · S/N 9329N491AVCirrus Design SR20 · S/N 9333N492AVCirrus Design SR20 · S/N 9361N493AVCirrus Design SR20 · S/N 9367N494AVCirrus Design SR20 · S/N 9375N496AVCirrus Design SR20 · S/N 9409N497AVCirrus Design SR20 · S/N 9413N4985EStitts Playboy SA-3A · S/N P245N498AVCirrus Design SR20 · S/N 9417N501KVCanadair CL-600-2B16 · S/N 5173N502AVCirrus Design SR20 · S/N 9459N503AVCirrus Design SR20 · S/N 9465N506AVCirrus Design SR20 · S/N 9469N507AVCirrus Design SR20 · S/N 9519N512AVCirrus Design SR20 · S/N 9521N5132PPiper PA-24 · S/N 24-145N513AVCirrus Design SR20 · S/N 9523N515AVCirrus Design SR20 · S/N 9560N517AVCirrus Design SR20 · S/N 9564N518AVCirrus Design SR20 · S/N 9568N520AVCirrus Design SR20 · S/N 9574N526AVCirrus Design SR20 · S/N 9578N527AVCirrus Design SR20 · S/N 9582N528AVCirrus Design SR20 · S/N 9586N5291PPiper PA-24-250 · S/N 24-331N542CDCirrus Design SR22 · S/N 1186N55ETMadson Jerome R RV6 · S/N 20489N56033Piper PA-28-235 · S/N 287310168N563WWJimenez Daniel L RV-8A · S/N 82390N56CPMooney M-20G · S/N 700003N58DGGarrison Donald L RV-8 · S/N 82397
Back to Goodyear, AZ