Burlington, NC
Registered aircraft · 72
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 = 'BURLINGTON' 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 = 'BURLINGTON' 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.
N108RGFlying K Enterprizes SKY RAIDER II · S/N SRII 007N110FBBeech 95-B55 (T42A) · S/N TC-2024N140TWCessna 140 · S/N 12403Registration pending, pending cancellationN141BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0625N15226Piper PA-28R-200 · S/N 28R-7335040N1523LFirefly Balloons FIREFLY 8 · S/N F8-2005N1525AArbc Inc DBA Lindstrand 90A · S/N 5365N1526SBeech P35 · S/N D-6969N1957XCessna 182H · S/N 18256057N199RNCessna 182Q · S/N 18266079N2185ECessna 172N · S/N 17271182N247RUTextron 560XL · S/N 560-6241N2967QPiper PA-32-300 · S/N 32-7940243N3030ECessna 172N · S/N 17271408N305LHPilatus PC-12/47G · S/N 3054N31694Piper PA-28R-201 · S/N 28R-7837244N319JPCessna 172M · S/N 17262752N33702Cessna M337B · S/N 337M-0142N33763Piper PA-28-151 · S/N 28-7515361N338NSBeech B-55 · S/N TC-1678N343LHPilatus PC-12/47E · S/N 2343N34YKBeech T-34B · S/N 144000N37099Balloon Works FIREFLY 7 · S/N F7-254N381MGCessna 172M · S/N 17265873N382MGCessna U206G · S/N U20605256N383MGCessna U206G · S/N U20606624N384MGCessna TU206G · S/N U20605272N402KDLindstrand Balloons 77A · S/N 5198N4052TBalloon Works FIREFLY 6B · S/N 10040N409LHPilatus PC-12/47E · S/N 2409N410SFPiper PA-28-140 · S/N 28-21000N4182NPiper PA-28-181 · S/N 2843380N4349XPiper PA-28-151 · S/N 28-7515447N43740Taylorcraft BC12-D · S/N 7399N45062Cameron Balloons US N-90 · S/N 6372N4576XPiper PA-28R-200 · S/N 28R-7635081N461ECEric P Minnis PA-18 REPLICA · S/N JA1810124N475LHPilatus PC-12/47E · S/N 2475N48842Cessna 152 · S/N 15280997N5004YCessna 172S · S/N 172S8961N50HUAviat A-1 · S/N 1320N517LHPilatus PC-24 · S/N 157N522LZLiszewski Walter F MERLIN GT · S/N M1191N530WCPilatus PC-12/45 · S/N 530N543LHPilatus PC-12/45 · S/N 543N584LKNelson Gary A MAGNUM · S/N 103MN5904APilatus PC-12/45 · S/N 583N6026YBeech A36 · S/N E-1451N608SMPilatus PC-12/47 · S/N 734N612KDLindstrand Balloons 60X · S/N 5501
Back to Burlington, NC