Collierville, TN
Registered aircraft · 110
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 = 'COLLIERVILLE' 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 = 'COLLIERVILLE' 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.
N1005DCessna 195A · S/N 7613N1049Piper J3C-65 · S/N 8453N1111YCessna 150B · S/N 15059511N11243Cessna 150L · S/N 15075276N114MVans RV-12IS · S/N 12174N117DHHudson David MERLIN · S/N 96049R8N1237HPiper PA-28-140 · S/N 28-7725137N1289DCessna 170A · S/N 19865N1325FCessna 172N · S/N 17272995N1336UCessna 172M · S/N 17267021N13WKKnight Wallace R II KNIGHT WALLACE RII P · S/N 200401N147CPHobgood Mitch VANS RV-4 · S/N 2146N15DACessna T210M · S/N 21061765N1623AMeagher Robert P RV-7 · S/N 74770N174TBAmerican Champion 8KCAB · S/N 1173-2017N1822NBeech V35B · S/N D-10377N18560Beech E17L · S/N 162N1934XCessna 182H · S/N 18256034N2241FCessna 310L · S/N 310L-0041N224PBCirrus Design SR22 · S/N 1754N250MTTumbiolo Michael J SEAREY · S/N 1DK045N2612SCessna 337C · S/N 337-0912N2643KCessna 180K · S/N 18053023N2698TQuicksilver Mfg GT500 R912 · S/N 0412N2981ECessna 172N · S/N 17271394N3030Zlin Aviation S R O ZLIN SAVAGE ICUB · S/N 0204N3062EAeronca 7AC · S/N 7AC-6651N30BTPiper PA-22 · S/N 22-1415N3216DBeech A36 · S/N E2916N3227GBeech A36 · S/N E-2927N322KACirrus Design SR22T · S/N 1185N324XRockwell International 112 · S/N 300N3282QPiper PA-28-140 · S/N 28-7725221N3462VCessna 195A · S/N 7187N347WTVans RV-12IS · S/N 12203N34829Cessna 177B · S/N 17702029N34SWCessna TR182 · S/N R18201077N35091Cessna 177B · S/N 17702202N3559CPiper PA-32-300 · S/N 32-7940279N360JPSukhoi SU-29 · S/N 74-01N3739MPiper PA-12 · S/N 12-2676N3763RCessna 172H · S/N 17255563N3811MPiper PA-28R-200 · S/N 28R-35200N400CZedaker Tom LANCAIR IVP · S/N 75N4760SDJI AGRAS T50 · S/N 1581F6BUB23BE001N256N48PFCessna 305A · S/N 23721N50PPBurkeen James R PIETENPOL · S/N 409686830N511RVans RV-12IS · S/N 12176N522CBPiper PA-24 · S/N 24-1939N533CVLindsey Brad A VANS RV7 · S/N 70437
Back to Collierville, TN