Waxhaw, NC
Registered aircraft · 82
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 = 'WAXHAW' 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 = 'WAXHAW' 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.
N118DEEnsing Dale W RV-6A · S/N 60061N11GKPiper PA-28-140 · S/N 28-23403N123TMCessna U206F · S/N U20601768N128LHHarrel Lee E JR VANS RV-8A · S/N 82377First renewal noticeN134CPMaule MT-7-235 · S/N 18070CN157HTextron 208 · S/N 20800668N158MBAlex M Bantum ECLIPSE 10 · S/N 08175451014N160MPAvid MAGNUM · S/N PROTOTYPEN1776CHawker Beechcraft HAWKER 900XP · S/N HA-0002N177CMPiper PA-32RT-300T · S/N 32R-7887273N18DEEnsing Dale W MINI MAX · S/N 9N195FYCessna 195A · S/N 16050N2024ABeech F33A · S/N CE-804First renewal noticeN207SRCessna T207A · S/N 20700623N2126GCessna 182A · S/N 51426N212PFCirrus Design SR20 · S/N 2285N21462Cessna 182P · S/N 18261646N2244ZPiper PA-32-300 · S/N 32-7940110N226RPTextron G36 · S/N E-4114N234DLPiper PA-32R-301T · S/N 32R-8329029First renewal noticeN238CSCessna T182T · S/N T18209038N239BCirrus Design SR22T · S/N 11127N242MBCirrus Design SR22 · S/N 0911N2430RMeltebeke Drew AIRCAM · S/N AC-246N24785Piper J3C-65 · S/N 3445N266PJJohnson Philip T 1/2 SCALE CORSAIR · S/N 266N26FBBluhm Raymond M VANS ACFT RV-4 · S/N 3810N2892ECessna 172N · S/N 17271363N28NRQuest KODIAK 100 · S/N 100-0024N301JABell Helicopter Textron Canada 206L-4 · S/N 52341N3077KBeech F33A · S/N CE-1070N3265FMooney M20E · S/N 670058N3454VCessna 150M · S/N 15076507N349RAS.O.C.A.T.A. MS893E · S/N 13178N365BTPilatus PC-6/B2-H4 · S/N 729N366RKRobinson Helicopter R66 · S/N 0650N36MBeech A36 · S/N E-206N3729EAeronca 11AC · S/N 11AC-S15N3771VCessna 140 · S/N 15064N384DMDiamond Aircraft Ind DA 40 · S/N 40.443N422ABPalmer Brendan A/Palmer Alecia KR2S · S/N 1274N434SRCirrus Design SR22 · S/N 2557N438TBeech V35B · S/N D-9256N4523ELynn James Mutch SPAD13C1 · S/N 4523N4569XPiper PA-28-140 · S/N 287625057N461FMHelio H-295 · S/N 1436N4758BCessna 180 · S/N 31656N4760CCessna TU206G · S/N U20605805N479STPilatus PC-12/45 · S/N 354N510JMCessna 510 · S/N 510-0051
Back to Waxhaw, NC