Fayetteville, TN
Registered aircraft · 33
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 = 'TN' 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 = 'TN' 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.
N105LVPatrick Saenen ZENITH CH 650B · S/N 16001N131JHHenry James R GLASTAR · S/N 5343N138BRSocata TB 9 TAMPICO · S/N 1528N161DWWolstenholme Dennis PIETENPOL AIR CAMPER · S/N 787-393N1715BBoeing A75 · S/N 758682N2320DCessna 170B · S/N 20472N2811CCessna 170B · S/N 26354N283ASEa Vision EA J100 · S/N EAVUAV502585872N316ENMitsubishi MU-2B-26 · S/N 349SAN317ACirrus Design SR22 · S/N 2105N365MMEurocopter AS 365 N2 DAUPHIN · S/N 6465N39JLAmerican Champion 8KCAB · S/N 1115-2012N4208DBeech G35 · S/N D-4411N48924Cessna 152 · S/N 15281051N48LEBeech 36 · S/N E-155N50SBBeech 95-B55 (T42A) · S/N TC-2134N5238XStachelski Edward D BOWERS FLYBABY 1-A · S/N 3812N52683Cessna 172P · S/N 17274579N551GBCessna 500 · S/N 500-0314N5552MCessna 152 · S/N 15284613Registration pendingN5555PPiper J3C-65 · S/N 20345N59XPCessna R172K · S/N R1722015N6171ZCirrus Design SR22 · S/N 0635N61LVCessna 172G · S/N 17253899N7219UBeech F33A · S/N CE-1053N7254SCessna 150H · S/N 15067954N7613XMaule M-6-235 · S/N 7498CN8897JPiper PA-28-180 · S/N 28-2873N928DHCirrus Design SR22T · S/N 10189N9658FHughes 269C · S/N 210090N98216Piper J-3 · S/N 18379N98534Piper J3C-65 · S/N 18744N985LFrench Larry A LION HEART · S/N GA-LH-001
Back to Fayetteville, TN