Skip to content

Registered aircraft · 41

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

N15ESBeaudoin Henri Paul SUPER CUBY · S/N 001Built 1988 · Cyr Gregory A N180MRKodiak KODIAK 100 · S/N 100-0341Built 2024 · State Of Maine Dept Of Marine Resources N18516Beech C23 · S/N M-2344Built 1981 · Maine Instrument Flight N185GNCessna A185F · S/N 18504131Norris Gary L N185SLCessna A185F · S/N 18504316Built 1981 · Department Of Inland Fisheries And Wildlife N2010ABeech C23 · S/N M-2066Built 1978 · Maine Instrument Flight N2012KBeech B19 · S/N MB-901Built 1978 · Maine Instrument Flight N2053LBeech B19 · S/N MB-812Built 1976 · Maine Instrument Flight N211SJCirrus Design SR20 · S/N 2451Built 2018 · Maine Instrument Flight N215MECirrus Design SR20 · S/N 9528Built 2023 · Maine Instrument Flight N2168WBeech B19 · S/N MB-659Built 1974 · Maine Instrument Flight Inc N2243LBeech C23 · S/N M-1890Built 1977 · Maine Instrument Flight N2397EBeech C23 · S/N M-1949Built 1977 · Maine Instrument Flight N23982Beech B19 · S/N MB-831Maine Instrument Flight N23HKBeech C23 · S/N M-1911Built 1977 · Maine Instrument Flight N24020Beech B19 · S/N MB-838Built 1977 · Maine Instrument Flight N2459VCessna 172S · S/N 172S10038Built 2005 · University Of Maine System N25BBeech 76 · S/N ME-49Maine Instrument Flight N321NECirrus Design SR20 · S/N 2675Built 2021 · Maine Instrument Flight N326VACirrus Design SR20 · S/N 9536Built 2023 · Maine Instrument Flight N3330MBeech 58 · S/N TH-1031Built 1979 · Maine Instrument Flight N4953ECessna A185F · S/N 18503919Built 1979 · Inland Fisheries And Wildlife N5339NCessna 182Q · S/N 18267656Maine State Police N5566RCessna 172F · S/N 17253159Built 1965 · Stoops Rickie L N5787HPiper PA-16 · S/N 16-403Built 1949 · Lagace Donald O N61368Cessna A185F · S/N 18504159Built 1980 · Department Of Inland Fisheries And Wildlife N622PDCirrus Design SR20 · S/N 9533Built 2023 · Maine Instrument Flight N6309KCessna T206H · S/N T20608865On Eagles Wings LLC N66126Beech C23 · S/N M-2382Built 1983 · Maine Instrument Flight N66293Beech C24R · S/N MC-674Built 1979 · Maine Instrument Flight N714JQCessna A185F · S/N 18504399Department Of Marine Resources N71UMCirrus Design SR20 · S/N 8671Built 2022 · University Of Maine System N7217HBeech 58 · S/N TH-1442Built 1984 · Maine Instrument Flight N799GAGrumman American Avn. GA-7 · S/N GA7-0090C And M Enterprises Inc N803MECirrus Design SR20 · S/N 9527Built 2023 · Maine Instrument Flight N8366ACessna 170B · S/N 25218Cyr Gregory A N878USRobinson Helicopter R44 · S/N 11454Built 2006 · Green Aviation N923ZEaa SPORT BIPLANE · S/N EB1Cyr Gregory A N9494NCessna A185F · S/N 18504365Built 1981 · Maine Department Of Inland Fisheries And Wildlife N9544QCessna 182S · S/N 18280291Built 1998 · Photo Services Unlimited N9731LBeech C23 · S/N M-1358Built 1971 · Maine Instrument Flight

Back to Augusta, ME