Registered aircraft · 21

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'COVINGTON' ORDER BY g.n_number

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 = 'COVINGTON'
  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 = 'COVINGTON'
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.

N15179Piper PA-28-140 · S/N 28-7225601Built 1972 · Henson Ricky T N264CBSeth Badje JA30 SUPERSTOL · S/N JA418-11-14Built 2015 · Mccalla Richard K N277BALet L 33 SOLO · S/N 940302Built 1994 · Wheeler Shaun W N2884FCessna 182J · S/N 18256984Built 1966 · Turner Michael B N2974XBellanca 7ECA · S/N 1346-80Anderson Keith N333WHHanks Wendell W VARIVIGGEN · S/N 333Built 1986 · Harris Robert W N35582Aerostar International XP CLASSIC LTD · S/N XP-3006Medicine Shoppe N3625KPiper PA-28-140 · S/N 28-23658Built 1967 · Acl Airplane Holding LLC N3807XBeech A36TC · S/N EA-179Built 1980 · Alpha Bravo Lima LLC N57166Talos Drones T60X · S/N 78KBN1L00A01FSRogers Jeffrey N57167DJI AGRAS T50 · S/N 63YBM6J00200F5High Vu Ag LLC N60MRGrumman American Avn. GA-7 · S/N GA-7-0060Built 1978 · Hansen Charles R N6437NAerostar International RAVEN S-55A · S/N S55A-3014Built 1986 · Norris Dennis R N803KAAir Tractor AT-802 · S/N 802-0955Built 2022 · Anderson Flying Service LLC N8061VCirrus Design SR22 · S/N 0649Built 2003 · Cheairs William T N81VALee David VELOCITY · S/N DM0043Frus Kevin N86LEMahan Fred/Ivan LONG-EZ · S/N 34Built 1987 · Harris Robert W N8BMBerkshire Mfg. CONCEPT 70 · S/N 8Built 1973 · Wheeler Shaun W N91341Piper PA-38-112 · S/N 38-82A0007Built 1982 · Wheeler Shaun W N962QCGrumman Acft ENG Cor-Schweizer G-164B · S/N 428BAnderson Flying Service LLC N9640Grumman Acft ENG Cor-Schweizer G-164A · S/N 1204Built 1974 · Harris Robert W

Back to Covington, TN