Honolulu, HI
Registered aircraft · 238
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 = 'HI' AND g.registrant_city = 'HONOLULU' 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 = 'HI' AND g.registrant_city = 'HONOLULU' 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.
N102ASGrumman American Avn. AA-5A · S/N AA5A0514N111GAPiper PA-31-350 · S/N 31-8152050N116PFSling SLING LSA · S/N 440AN119MJRobinson Helicopter R44 II · S/N 13406N1202PCostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 056/USN1203PCostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 057/USN1214PCostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 061/USN1216PCostruzioni Aeronautiche Tecna P2012 TRAVELLER · S/N 062/USN128ARPiper PA-44-180 · S/N 4496218N129CGCessna 208B · S/N 208B1290N13065Cessna 172M · S/N 17262471N131MMMachado Mark A VELOCITY RG · S/N 001N13365Cessna 172M · S/N 17262703N145KACessna 208B · S/N 208B2019N1468ECessna 172S · S/N 172S10446N1537ZSchweizer 269C-1 · S/N 0244N161DSAerotek PITTS S-2A · S/N 2136N1635KLuscombe 8A · S/N 4362N171EXDassault FALCON 7X · S/N 24N172CNTextron 172S · S/N 172S12458N176TATextron 172S · S/N 172S12115N178HPEdvinson-Lennart HP-18 · S/N 18-123N187PFSling SLING LSA · S/N 444AN18GHMcdonnell Douglas Helicopter 500N · S/N LN014N19867Cessna 172M · S/N 17260818N202HAAirbus A321-271N · S/N 7917N204HAAirbus A321-271N · S/N 7959N208HAAirbus A321-271N · S/N 8123N208PKCessna 208B · S/N 208B1143N21030Piper PA-28-161 · S/N 28-7816529N2120MCirrus Design SR20 · S/N 2478N214HAAirbus A321-271N · S/N 8157N215HAAirbus A321-271N · S/N 8266N216HAAirbus A321-271N · S/N 8471N217HAAirbus A321-271N · S/N 8578N218HAAirbus A321-271N · S/N 8764N220HAAirbus A321-271N · S/N 8872N221LMShort Bros SD3-60 · S/N SH3722N222PECessna 310R · S/N 310R0632N223HAAirbus A321-271N · S/N 9060N226HAAirbus A321-271N · S/N 9127N228HAAirbus A321-271N · S/N 9274N22UAUrban Air Sro UFM-13 LAMBADA · S/N 117/13N236KACessna 208B · S/N 208B2034N240VAVans RV-12 · S/N 12015N243CYAviat A-1B · S/N 2081N248KACessna 208B · S/N 208B2408N248PACessna 208B · S/N 208B0134N24QXLeading Edge Aerial Tech PV40X · S/N 1937511483N2519LCessna 172H · S/N 17255719
Back to Honolulu, HI