Morehead City, NC
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 = 'NC' AND g.registrant_city = 'MOREHEAD CITY' 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 = 'NC' AND g.registrant_city = 'MOREHEAD CITY' 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.
N141PCRaytheon 58 · S/N TH-2091N2143PPiper PA-28-236 · S/N 28-7911103N24NKPfannenstiel Nicholai W ST-L · S/N 22N266NBoeing A75N1(PT17) · S/N 75-598N2832DBeech D17S · S/N 1025First renewal noticeN3214CBeech E35 · S/N D-3878N387CWSling SLING LSA · S/N 421AN4293UCessna 150D · S/N 15060293N4525CGulfstream American AA-5B · S/N AA5B1117N508AKAir Tractor AT-502A · S/N 502A-3277N581GLCessna LC41-550FG · S/N 411129N6068GCessna 150K · S/N 15071568N63921Cessna 182T · S/N 18281408N64377Cessna 172M · S/N 17265204N6902ACessna 172 · S/N 29002N700LTSocata TBM 700 · S/N 316N735EDCessna A185F · S/N 185-04443N745EARaytheon B200 · S/N BB-1745N760XJCessna 750 · S/N 750-0260N780XJCessna 750 · S/N 750-0280N782XJCessna 750 · S/N 750-0282N784XJCessna 750 · S/N 750-0084N790XJCessna 750 · S/N 750-0070N813MJGiallo Joseph F II RV-7A · S/N 71014N818JGGiallo Joseph F II RV-10 · S/N 41360N8510SCessna 182H · S/N 18256610N8605KCessna 340A · S/N 340A1241N897TPPowrachute AIRWOLF 912ULS · S/N A359ULSN90225Weatherly 620B · S/N 1622N90271Hughes 269A · S/N 65-18261N995JBBetts John P FISHER CLASSIC · S/N CO118
Back to Morehead City, NC