Owls Head, ME
Registered aircraft · 24
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'OWLS HEAD' 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 = 'OWLS HEAD' 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.
N104GCZlin 526 · S/N 1065N11DOwlshead Transportation Museum ETRICH TAUBE · S/N D2N13158Pitcairn PA-7S · S/N 151N13442Waco UBF · S/N 3766N14574Swanson SPAD XIII · S/N C-1First renewal noticeN1GJCurtiss D · S/N M-4N207JPCessna 207 · S/N 20700255N2086Curtiss-Aero Meridian JN-4-D JENNY · S/N 34094N22581Standard J-1 · S/N 581First renewal noticeN27226Swanson NIEUPORT 28 · S/N C-1First renewal noticeN274TCessna 180H · S/N 18052244N425FKCianchette FOKKER DR-I-TRI-PLAN · S/N 2001N439FKFokker FOKKER C-4 · S/N 4127N46775Piper PA-18-135 · S/N 18-3594N477NTravel Air D-4000 · S/N 1379N5082HPiper PA-11 · S/N 11-981N5138Brian T Coughlin SOPWITH PUP · S/N 1916N5141WPiper PA-28 · S/N 28-171N55361Boeing A75N1(PT17) · S/N 75-1795N66349Cessna 150M · S/N 15075990N7565RPiper PA-28-140 · S/N 28-22129N75980Boeing B75N1 · S/N 75-6746N767FPietenpol P-4 · S/N 3712N928Gardiner F.E.8. · S/N 298
Back to Owls Head, ME