New Bern, NC
Registered aircraft · 66
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 = 'NEW BERN' 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 = 'NEW BERN' 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.
N100RBBeech F33A · S/N CE-1586N1126MCessna 172L · S/N 17259803N1188Cessna 310D · S/N 39152N1368YPryor Davie Dean BD-5B · S/N 9469N15EFPiper PA 46-350P · S/N 4636195N1648QCessna 150L · S/N 15072948N1696XCessna 210L · S/N 21060731N1809MCessna 337F · S/N 33701409N1837LBeech V35B · S/N D-9881N19282Cessna 150L · S/N 15074301N1951MBeech 95-B55 (T42A) · S/N TC-2255N223XPAndrew G Shorter PANTHER LS · S/N 033N254PCBeech 300 · S/N FA-160N266PZLucas Christopher R RV-14A · S/N 140666N269MLBeech 200 · S/N BB-760N26EYFleming Don G GLASAIR III · S/N 3048N30521Piper PA-44-180 · S/N 44-7995076Sale reported, pending cancellationN3056UCessna 172E · S/N 17250656N310BWSukhoi SU-31 · S/N 02-03N3187AMaule MXT-7-180A · S/N 21011CN33372Piper PA-28R-200 · S/N 28R-7535139N333VPBeech A36 · S/N E-2161N358RXPeter Povich REV X · S/N X1040N36JHawker Beechcraft G36 · S/N E-3771N3712KGlobe GC-1B · S/N 1405N407RBell 407 · S/N 53451N419RXEvolution REV X · S/N X1001N4228ZPiper PA-18-150 · S/N 18-8453N4316RCessna 172M · S/N 17263069N43NWCessna 525 · S/N 525-0543N43WBNorth American SNJ-5 · S/N 44020N444DXUllman David VELOCITY SEFG · S/N SFG035N44TSMooney M20J · S/N 24-3321N461TACessna 680 · S/N 680-0519N4756Siai-Marchetti SM 1019 · S/N NC.068N50YKYakovlev YAK-50 · S/N 842806N5123Dassault MYSTERE-FALCON 50 · S/N 123N527WPPiper PA-28R-180 · S/N 28R-30977N540BBBsr-Hess Race Cars GLASAIR III · S/N 7191N5470Grumman Acft ENG Cor-Schweizer G-164A · S/N 1166N569CDRobinson Helicopter R44 II · S/N 12257N5755TCessna 172E · S/N 17251655N630DADiamond Aircraft Industries HK 36 TTC · S/N 36630N63248Cessna 150M · S/N 15077202N64314Cessna 172M · S/N 17265164Registration pendingN652CFCessna 150D · S/N 15060585N6591ABeech C23 · S/N M-2381N68FTCessna 150H · S/N 15068730N69SUSukhoi SU-31 · S/N 03-05N6EKCessna 150G · S/N 15066827
Back to New Bern, NC