Registered aircraft · 19

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 = 'ME' AND g.registrant_city = 'GREENVILLE' 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 = 'ME' AND g.registrant_city = 'GREENVILLE'
  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 = 'ME' AND g.registrant_city = 'GREENVILLE'
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.

N129SYCessna 172N · S/N 17270741Built 1978 · Daigle Danny N130QDouglas DC3-G202A · S/N 11761Built 1943 · Hbf Inc N180NMCessna 180J · S/N 18052328Built 1973 · Reitman John M N183MJohn Reitman AL18 · S/N AL-373Built 2023 · Reitman John N185NDCessna A185F · S/N 18504369Built 1982 · Folsom Rodney B N1872GChampion 7ECA · S/N 614Mcninch Floyd S N20VCSocata TB-20 TRINIDAD · S/N 782Danny J Daigle LLC N30580Piper J3C-65 · S/N 4950Built 1940 · Hofbauer Jane E N397TCCessna T206H · S/N T20608397Built 2003 · Bravo & Bravo LLC N46300Cessna 180J · S/N 18052413Built 1973 · Mason Steven O N54BKCessna 182R · S/N 18268073Built 1981 · Danny J Daigle LLC N6865ZCessna 421C · S/N 421C1068Barriault Ronald F N71JHCessna 180H · S/N 18051678Built 1966 · Jacks Air Serv Inc N7345GCessna 172K · S/N 17259045Built 1970 · Jacks Air Service Inc N747FSSchryver Fred R RV-8 · S/N 81337Built 2003 · Sea Rogue Enterprises Inc N784AWCessna A185F · S/N 18502251Built 1973 · Sea Rogue Enterprises Inc N880WSTextron 172S · S/N 172S11661Built 2015 · Department Of Inland Fisheries And Wildlife N96809Cessna 172P · S/N 17276117Built 1984 · Folsom Realty Group Inc N97FACessna A185F · S/N 18504373Built 1982 · Jalbert John E

Back to Greenville, ME