Maryville, TN
Registered aircraft · 85
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 = 'MARYVILLE' 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 = 'MARYVILLE' 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.
N101HTBeech J35 · S/N D-5722N111ZXMooney M20J · S/N 24-3105N125SCEurocopter AS 350 B2 · S/N 3904N128WPPiper PA-32-300 · S/N 32-40579N1294EAeronca 7AC · S/N 7AC-4855N13045Cameron Balloons Z-90 · S/N 6440N171YBeech J35 · S/N D-5467N175DSCirrus Design SR22 · S/N 10257N18FLMoncrief Keith D SERIES 5 KITFOX · S/N 59860157N1920DBeech C35 · S/N D-3192N1CHEmbraer Executive EMB-505 · S/N 50500888N1KAEmbraer Executive EMB-505 · S/N 50500818N200FCConover Forest R CONOVER SKYBOLT · S/N 1N20290Cessna 172M · S/N 17261163N2079ZCessna 150C · S/N 15059879N219CDecarlo Daniel J CHALLENGER II · S/N 001N22NPBeech S35 · S/N D-7354N246MLRoth Frank Ronald AVID AIRCRAFT · S/N 1186-DN2513VCessna 170 · S/N 18016N2684DCessna 170B · S/N 20836N268TPiper PA-18-105 SPECIAL · S/N 18-2382N272CMHigginbotham Ken LANCAIR 4 P · S/N LIV-374N2780ZSchweizer SGS 1-26B · S/N 299N2890UCessna 172D · S/N 17250490N30173Piper PA-32RT-300T · S/N 32R-7887270N3073BBarche Melvin E BABY ACE · S/N 100N32413Piper PA-28-180 · S/N 28-7505058N35822Piper J5A · S/N 5-786N3642Thibodeau Robert J JR ACE · S/N 6466N372DMBuckeye PPC DREAM MACHINE · S/N 4509N38422Piper J5A · S/N 5-972N401BTCessna 401 · S/N 401A0002N4163YBellanca 7GCBC · S/N 959-77N42201Piper J3C-65 · S/N 14443N4253UCessna 150D · S/N 15060253N4410DBeech G35 · S/N D-4572N4525UGulfstream American AA-5B · S/N AA5B1122N47474Aeronca 0-58B · S/N 058B-7022N4807PCessna 180 · S/N 18053182N498JBBriggs James D RV-9A · S/N 90498N5184ECessna 172N · S/N 17271758N524YGrumman G-164 · S/N 161N5487SCessna 337B · S/N 337-0587N5618FAlon A2 · S/N A-218N5650SBeech A23-24 · S/N MA-68N565KGCessna 182P · S/N 18261775N566AJJones Alan D TEAM 1400Z · S/N 566N56CHEmbraer EMB-550 · S/N 55000081N5943CBeech C35 · S/N D-3304N5975CBeech C35 · S/N D-3327
Back to Maryville, TN