Clarksville, TN
Registered aircraft · 79
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 = 'CLARKSVILLE' 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 = 'CLARKSVILLE' 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.
N100VUWhite Gary P WILDCAT · S/N 001N2057ABeech A36 · S/N E-1420N2297YCessna 177 · S/N 17700097N232KRStout Randy F JUST AC HIGHLANDER · S/N JA219-1010N244AKPiper PA-18-150 · S/N 18-8209016N2472VPiper PA-38-112 · S/N 38-82A0064N2544WLancair LC41-550FG · S/N 41530N266THDJI T40 · S/N 1581F574B226A00102FTN2797HEngineering & Research 415-C · S/N 3422N28944Engineering & Research 415-C · S/N 3394N303JPCessna T303 · S/N T30300067N3253VCessna 150M · S/N 15076443N34PWMooney M20J · S/N 24-1203N3632Black Horse Model PA18 SUPER CUB · S/N BH172010N3633Hexemodel CZ KA4 RHOENLERCHE SUA · S/N RY01N3659CCessna 180 · S/N 31158N3741JCessna 150G · S/N 15065041N39CHStinson 108 · S/N 108-127N403SHHelicopteres Guimbal CABRI G2 · S/N 1196N421VWBrown Harold D S-14 AIRAILE · S/N 0804138N422CJLeturgey James D LONG EZE · S/N 537First renewal noticeN4231NCessna 120 · S/N 13920N4528FPiper PA-28R-200 · S/N 28R-7635414N465RFTextron 525C · S/N 525C0421N4821Debenair SEAREY · S/N 1DK200N484JLHelicopteres Guimbal CABRI G2 · S/N 1325N488ACRobinson Helicopter R44 II · S/N 13791N4918JPiper PA-28R-180 · S/N 28R-30638N492KVVaughn Keith VAUGHN CHALLENGER II · S/N CH2-0603-CW-2335N4941ACessna 310R · S/N 310R1407N4963NCessna 182Q · S/N 18267485N504QMJames D Register CHALLENGER II · S/N CH2-1005-2686N5147SPiper PA-28-180 · S/N 28-7105001N514PCBeech V35A · S/N D-8967N5213WPiper PA-28-160 · S/N 28-249N521PTCirrus Design SR20 · S/N 9194N522TSCessna 172C · S/N 17248805N5265ECessna 172N · S/N 17271804N5349MPiper PA-32R-301T · S/N 3257307N552RYCessna 172F · S/N 17253073N5614LAmerican AA-1 · S/N AA1-0016N5658UPiper PA-28-140 · S/N 28-26454N585RJBeech 58 · S/N TH-1479N5908QMooney M20E · S/N 819N60288Cessna 150J · S/N 15070199N6070FCessna 182P · S/N 18264086N61474Cessna 182T · S/N 18281370N6299YPiper PA-23-250 · S/N 27-3550N642SRCirrus Design SR22 · S/N 2195N668CBCessna 550 · S/N 550-1068
Back to Clarksville, TN