Morrisville, NC
Registered aircraft · 34
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 = 'MORRISVILLE' 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 = 'MORRISVILLE' 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.
N108YZGopalan Hariharan 4 PLACE · S/N 986N15246Piper PA-28-180 · S/N 28-7305041N164LACostruzioni Aeronautiche Tecna P2010 · S/N 371/USN213CHRaytheon 58 · S/N TH-2079N224PMCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1086/USN229FGPiper PA-28-181 · S/N 28020020N258LCLiberty Aerospace LIBERTY XL-2 · S/N 0080N279LACostruzioni Aeronautiche Tecna P2010 · S/N 377/USN311PWAero Commander 500-A · S/N 500A-1106-54N315VVCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1110/USN43972Taylorcraft BC12-D · S/N 7631N44374Taylorcraft BC12-D1 · S/N 10174N4668HMooney M20J · S/N 24-0805N471BLDiamond Aircraft Ind DA 40 NG · S/N 40.NC111N4734WRockwell International 114 · S/N 14064N5201NMooney M20J · S/N 24-0581N61LHDiamond Aircraft Ind DA 40 · S/N 40.415N7120EPiper PA-44-180 · S/N 4496471N714RZBeechcraft G36 · S/N E-4047N79PAPiper PA-28-181 · S/N 2881293N80FGPiper PA-28-181 · S/N 2881562N8802FHughes 269A · S/N 0133Revoked, canceledN956GVCostruzioni Aeronautiche Tecna P2006T · S/N 229/USN960RAviat A-1C-180 · S/N 3003N990FGPiper PA-28-181 · S/N 2881649N991FGPiper PA-28-181 · S/N 2881869N992FGPiper PA-28-181 · S/N 2881693N993FGPiper PA-28-181 · S/N 2881830N994FGPiper PA-28-181 · S/N 2881831N994SBeech H35 · S/N D5180N995FGPiper PA-28-181 · S/N 2881883N996FGPiper PA-28-181 · S/N 2881598N997FGPiper PA-28-181 · S/N 2881954N998FGPiper PA-28-181 · S/N 2881960
Back to Morrisville, NC