Fayetteville, NC
Registered aircraft · 86
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 = 'FAYETTEVILLE' 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 = 'FAYETTEVILLE' 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.
N100BVPiper PA-38-112 · S/N 38-78A0262N1061WBeech F33A · S/N CE-427N10888Cessna 150L · S/N 15075109N11208Cessna 150L · S/N 15075255N1639JPiper PA-28-140 · S/N 28-24027N175CDCirrus Design SR20 · S/N 1065N1808SBeech B-60 · S/N P-573N1857TPiper PA-28-140 · S/N 28-7225006N193JSCessna 172M · S/N 17265118N194HABeech H35 · S/N D-5052N1970HPiper PA-28-161 · S/N 28-7716071N20948Cessna 182P · S/N 18261316N2177ZPiper PA-28-236 · S/N 28-7911154Registration pendingN217TJCirrus Design SR22 · S/N 2291N219HFTextron 525 · S/N 525-0907N22253Cessna 150H · S/N 15068170N22TYRaytheon 58 · S/N TH-1826N23193Cessna 150H · S/N 15068785N2345VCessna 170B · S/N 25056N237SFPilatus PC-12/47E · S/N 2152N242PNMoravan Z242L · S/N 0670N244BMPiper PA-28-151 · S/N 28-7415157N2482TNorth American NAVION G · S/N NAV-4-2482N2823WMooney M20J · S/N 24-1101N28266Carnevale Victor N BOWERS FLAY BABY I · S/N 1N29CJDean THORP T-18 · S/N 621N3118AGaver Kenneth Dale JR AVID FLYER · S/N 788N3162MPiper PA-12 · S/N 12-1842N3290QPiper PA-28-161 · S/N 28-7716147N33563Piper PA-28-151 · S/N 28-7515346N350MXPiper PA46R-350T · S/N 4692001N36PEMooney M20K · S/N 25-0722N3950YCessna 210D · S/N 21058450N4266FCessna 172 · S/N 46166N4271TPiper PA-28-140 · S/N 28-7225111N42926Piper J3C-65 · S/N 15277N43BRBell Textron Canada 407 · S/N 56312N443VJCirrus Design SF50 · S/N 0443N444SBeech 58P · S/N TJ-490N44561Piper J3C-65 · S/N 18130N4521GQuad City Ultralight Acft CHALLENGER I · S/N 0295 0550N4552PPiper PA-23-250 · S/N 27-58N4603JPiper PA-28R-180 · S/N 28R-30482N461RMCessna 172I · S/N 17257043N497BWDorance Giddings RV-9A · S/N 90762N5046DBellanca 8KCAB · S/N 512-79N5333MPiper PA-28-161 · S/N 28-7816140N5346QCessna 150L · S/N 15073246N55897North American T-6G · S/N 49-3144AN5629YPiper PA-23-250 · S/N 27-2741
Back to Fayetteville, NC