Skip to content

Registered aircraft · 35

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

N110USocata TB-20 TRINIDAD · S/N 595Darnell Charlie N112CSchweizer SGS 1-26C · S/N 482Built 1970 · Wilkinson Ephriam B N126BSchweizer SGS 1-26B · S/N 275Built 1964 · Wilkinson Ephriam B N126ESchweizer SGS 1-26E · S/N 608Built 1974 · Wilkinson Ephriam B N126WSchweizer SGS 1-26E · S/N 524Wilkinson Ephriam B N127DJRobinson David PITTS 12 · S/N 127Built 2003 · Robinson David N12WWCessna 305C (0-1E) · S/N 24544Built 1957 · Wilkinson Ephriam N1882YCessna 172C · S/N 17249482Dunlap Alexander W N1969PCirrus Design SR22 · S/N 2481Built 2007 · Pie In The Sky Aviation LLC N2406WSchweizer SGS 1-26B · S/N 350Built 1966 · Wilkinson E B N2545KLancair LC41-550FG · S/N 41039Built 2004 · Toscano Holdings N2790LCessna 172H · S/N 17255990Built 1967 · Wells Mark L N2797ZSchweizer SGS 1-26C · S/N 293Built 1966 · Wilkinson Ephriam B N3167ACessna 170B · S/N 25811Built 1953 · Wells Mark L N31DLMooney M20J · S/N 24-0475Built 1978 · Loy David Parker N324PRaytheon G36 · S/N E-3730Bishop Barry T N360KTRhodes Howard GLASAIR 3 RG · S/N 3379Built 2024 · Rhodes Howard N427CQDiamond Aircraft Ind DA 40 · S/N 40.255Built 2002 · Stinger Capital Partners LLC N440AMAeroprakt Manufacturing SP Zoo A22LS · S/N 498Built 2024 · Hultman David R N444CPPiper PA-30 · S/N 30-230Built 1963 · Mercure Ryan K N5784SSchweizer SGS 1-26D · S/N 401Built 1968 · Wilkinson E B N5831VSchweizer SGS 1-26C · S/N 259Built 1964 · Wilkinson Ephriam B N6092SBeech V35B · S/N D-9830Built 1975 · Robinson David John N738LHCessna 172N · S/N 17270058Lh Enterprise LLC N8641RSchweizer SGS 1-26B · S/N 184Built 1962 · Wilkinson Ephriam B N8670RSchweizer SGS 1-26A · S/N 198Built 1963 · Wilkinson Ephriam B N8963MBeech 35-B33 · S/N CD-721Built 1963 · Spicer William Harold III N901PBWilliam K Swayne CCX-2000 · S/N CCX-2000-0102Built 2020 · Smith Ben R N901SMMurphy Steven J RV-9A · S/N 91630Murphy Steven J N90PWDelta Rafal Mikke B1-PW-5 SPECIAL · S/N 05.002.04Built 2007 · Wilkinson Ephriam B N910MXSocata TBM 700 · S/N 1186Built 2017 · Smith Ben R N911NBExtra Flugzeugbau EA 300/L · S/N 077Peeler Aviation N9650UGrumman American Avn. AA-1C · S/N AA1C0087Built 1977 · French James R N96LTBRM Aero S R O BRISTELL LSA · S/N 628/2022Built 2022 · Toothacre Farms LLC N9918VCessna 180H · S/N 18051770Built 1966 · Gray Paul W

Back to Eads, TN