Advance, NC
Registered aircraft · 44
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 = 'ADVANCE' 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 = 'ADVANCE' 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.
N1030NNew Piper PA-32R-301 · S/N 3246242N106LCLarry Carpenter SPORTCOPTER VORTEX M · S/N 142N11TJCessna 310R · S/N 310R1683N125SWWilliam H May BEARHAWK PATROL · S/N P218N134CDBeech A45 · S/N G-717N15013Piper PA-28R-200 · S/N 28R-7235318N155WCBeech E-55 · S/N TE-1193N1603ECessna 172N · S/N 17271062N182TRCessna 182S · S/N 18280160N18630Cessna 150L · S/N 15074000N19231Cessna 150L · S/N 15074258N204AWAirborne Windsports PTY EDGE XT-582-L · S/N XT-582-0053N296SLAirplane Factory SLING LSA · S/N 296N2990Cessna 305C (0-1E) · S/N 0038N30629Piper J3C-65 · S/N 4991N3260SCessna 182G · S/N 18255760N3395KGlobe GC-1B · S/N 1388N3466SCessna 182H · S/N 18255866N3559QPiper PA-32R-301T · S/N 32R-8029022N400CECessna 421B · S/N 421B0930N459SRAmerican Legend AL3 · S/N AL-1182N4632XCessna 150G · S/N 15064682N46736Cessna 172K · S/N 17257460N4786FCessna TP206C · S/N P206-0470N47STSturgis John Michael RV-4 · S/N 2739N487JFEa Vision EA J100 · S/N EAVUAV502586174N4983BEa Vision EA J100 · S/N EAVUAV502586547N515ZDavid B Mcrae CH 750 STOL · S/N 7911N53080Cessna 177RG · S/N 177RG1340N531GSPiper PA-28R-201 · S/N 28R-7837019N562JWaco Classic YMF-F5C · S/N F5C-8-139N5876ECessna 150 · S/N 17376N6179ECessna 172 · S/N 46279N649TCessna 182S · S/N 18280261N65702Lake LA-4-200 · S/N 607N6636UMooney M20D · S/N 131N734MTCessna 172N · S/N 17268966N76WEEnglert William VANS RV-4 · S/N 2667N84205Aerofab LAKE LA-250 · S/N 83N88WNAnglin Rober E III VANS ACFT 8A · S/N 80888N92815Cessna 182N · S/N 18260372N954CStinson 108-3 · S/N 108-3954N96649Taylorcraft BC12-D · S/N 8949N9996RBeech M35 · S/N D-6483
Back to Advance, NC