Registered aircraft · 17

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

N163PSDiamond Aircraft Ind DA 50 C · S/N 50.C.A.A.015Built 2022 · Just Winging It LLC N26279Stinson 10 · S/N 7560Built 1940 · Dorris Terry E N27DHBeech V35B · S/N D-9149Built 1970 · Mcavoy Sean M N309LLCessna 177RG · S/N 177RG1346Sweepyacres LLC N4605MBeech A36 · S/N E-1246Built 1978 · Johnson Plane Services LLC N483TSDiamond Aircraft Ind DA 42 · S/N 42.AC083Built 2007 · Double Diamond Aviation LLC N603MHCirrus Design SR22 · S/N 4629Built 2018 · Plane Company LLC N60779Cessna 162 · S/N 16200219Built 2012 · Baggett Robert E N7123UMooney M20C · S/N 2742Built 1964 · Matherly Frank N7581WPiper PA-28-180 · S/N 28-1523Built 1964 · Sutherland Joel C N787RMBeech F33A · S/N CE-1719Built 1993 · Johnson Plane Services N803DJCessna 150M · S/N 15078798Built 1976 · Lyle Chase Thomas N8071PPiper PA-24-250 · S/N 24-3318Built 1962 · Matherley Frank N825MECubcrafters CC11-160 · S/N CC11-00372Plane Company LLC N860ABeech F33A · S/N CE-934Built 1980 · Johnson Plane Services LLC N88ECEurocopter EC120B · S/N 1195Built 2001 · Plane Company LLC N96EJSchickli Edward J JR PIEL EMERAUDE · S/N 001Dorris Terry

Back to Greenbrier, TN