Pinehurst, NC
Registered aircraft · 28
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 = 'PINEHURST' 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 = 'PINEHURST' 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.
N144FACzech Sport PIPER SPORT · S/N P1001031N240PCCessna T240 · S/N T24002016N2660WMooney M20E · S/N 989N267PCirrus Design SR22T · S/N 11302N28GMGrumman American Avn. AA-5A · S/N AA5A0272N29FMMooney M20J · S/N 24-3406N33475Piper PA-34-200T · S/N 34-7570123N3487MPiper PA-12 · S/N 12-2331N394CPCirrus Design SR22 · S/N 3079N4022PHarpster R E/Harpster D S HAWK ARROW TANDEM · S/N H1143-A-TRI-2706N4395HMooney M20J · S/N 24-0724N47551Piper PA-28R-201T · S/N 28R-7703398N485DVCirrus Design SR22 · S/N 4473N521BTCirrus Design SR22 · S/N 0752N522RWKnapp John KITFOX II · S/N 0076N5513NCessna T182 · S/N 18267764N562ELBeech V35B · S/N D-9174N716BLCirrus Design SR22 · S/N 1314N723EBCirrus Design SR20 · S/N 1387N764JJabiru Aircraft PTY J230-D · S/N 873N825AJBeech 95-B55 (T42A) · S/N TC-2050N832JHCirrus Design SR20 · S/N 1296N904MMMooney M20R · S/N 29-0396N9139YMooney M20J · S/N 24-3218N9270PPiper PA-24-260 · S/N 24-4770N933TMBeech F33A · S/N CE-1744N9422LAmerican AA-1A · S/N AA1A-0222N9435BCessna 172RG · S/N 172RG0821
Back to Pinehurst, NC