Cottonwood, AZ
Registered aircraft · 31
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 = 'COTTONWOOD' 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 = 'COTTONWOOD' 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.
N1005James Snider SUPERSTOL-XL · S/N JA478-12-15N12KCBeech S35 · S/N D-7867N1322JRockwell International 112B · S/N 513N1773WBeech V35B · S/N D-9413N18775Beech B19 · S/N MB-846N1947MBeech S35 · S/N D-7547N28FSPricer Kurt DAVIS DA-2A · S/N 28N290DWWright Douglas J S18-160 · S/N 2023-002N3096PPiper PA46-500TP · S/N 4697178N310ARCessna 310R · S/N 310R1387N310LACessna 310R · S/N 310R0092N313AMPiper PA-28-236 · S/N 28-8011015N352VHAerospatiale AS350BA · S/N 1838N38TCPiper PA-31-310 · S/N 31-96N40PTSteven J Kellander KITFOX S7 SUPERSPORT · S/N KA13343278N4264CCessna 340A · S/N 340A0516N435CRyan NAVION B · S/N NAV-4-2167BN45044Head Balloons AX8-88 · S/N 162N45SXRyan Anthony W SONEX · S/N 0997N5231TCessna R182 · S/N R18201839Registration pendingN6203LAmerican AA-1B · S/N AA1B-0003N700RTMooney M20R · S/N 29-0097N7240ACessna 172 · S/N 29340N759WECessna 182Q · S/N 18266311Registration pendingN787SYDiamond Aircraft Ind DA 40 NG · S/N 40.N320N801HLPiper PA-31T · S/N 31T-8020016N888RJPiper PA-23-250 · S/N 27-7305139N916AMAerospatiale AS350 B2 ECUREUIL · S/N 2404N927LBAerospatiale AS350BA · S/N 2347N9481QBeech F33A · S/N CE-371N9555QBeech V35 · S/N D-8193Registration pending
Back to Cottonwood, AZ