Kinston, NC
Registered aircraft · 68
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 = 'KINSTON' 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 = 'KINSTON' 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.
N103CWBeech 300 · S/N FA64N167XBritish BAC 167 STRIKEMASTER · S/N 778N209JSTextron 172S · S/N 172S13008N221JSTextron 700 · S/N 700-0078N245JSCessna 208B · S/N 208B5154N249JSTextron 172S · S/N 172S13011N259JSTextron 172S · S/N 172S13012N283BBombardier BD-100-1A10 · S/N 20252N294JSTextron 208B · S/N 208B5643N2984Bowers Fly Baby 1-A · S/N 1780N308AGDJI AGRAS T40 · S/N 64TBK8F001003TN390JSBombardier BD-100-1A10 · S/N 20620N391JSBombardier BD-100-1A10 · S/N 20736N45082Cessna 150M · S/N 15076727N5265RCessna 172M · S/N 17263479N52DTTrojan David J TROJAN-ZENAIR 601HDS · S/N 63316N55046Volksplane VP-1 · S/N V3590N568MADJI AGRAS T100 · S/N ASHCNAG00108JQN65794Piper PA-28-140 · S/N 28-23302N69036Cessna 152 · S/N 15282451N6FGPiper PA-28-140 · S/N 28-7425297N701JSTextron 525B · S/N 525B0607N702JSTextron 525B · S/N 525B0704N707JSTextron 525B · S/N 525B0719N714JSTextron 525B · S/N 525B0720N715JSTextron 525B · S/N 525B0705N743JSTextron 525B · S/N 525B0707N749JSTextron 525B · S/N 525B0708N751JSCessna 525B · S/N 525B0413N753JSCessna 525B · S/N 525B0100N7582LDJI PHANTOM 2 · S/N PH636141584N758XLDJI PHANTOM 2 VISION · S/N PH636054955N799JSTextron 525B · S/N 525B0649N7YEHester Walker WH4 HARPOON · S/N 0004N803JSCessna 560XL · S/N 560-5272N809JSCessna 560XL · S/N 560-5094N80ERRouse Eric HARMON ROCKET · S/N 71N81038Byrd Melvin Gene CHALLENGER II · S/N CH20788CW0344N824JSCessna 560XL · S/N 5605536N833JSCessna 560XL · S/N 5605107N835JSCessna 560XL · S/N 560-5813N836JSCessna 560XL · S/N 560-5186N837JSCessna 560XL · S/N 560-5164N838JSCessna 560XL · S/N 560-5237N840JSCessna 560XL · S/N 560-5282N841JSCessna 560XL · S/N 560-5253N843JSCessna 560XL · S/N 560-5343N844JSCessna 560XL · S/N 560-5344N845JSCessna 560XL · S/N 560-5180N8483HSiverts Marwood TERMITE · S/N 509
Back to Kinston, NC