South Portland, ME
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
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 = 'SOUTH PORTLAND' 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 = 'SOUTH PORTLAND' 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.
N119UBritish Aerospace BAE 125 SERIES 1000A · S/N 259007Registration pending, canceledN17011Cessna 182T · S/N 18282010N240BSAerofab LAKE LA-250 · S/N 36N44226Taylorcraft BC12-D1 · S/N 10026N4818DCessna 172N · S/N 17272367N515LRBritish Aerospace BAE 125 SERIES 1000A · S/N NA1006N52SMBritish Aerospace BAE 125 SERIES 1000A · S/N NA1009N533LRCorporate Jets BAE 125-1000A · S/N 259033N5374DCessna 180A · S/N 50272N544LRRaytheon Corporate Jets HAWKER 1000 · S/N 259044N548LRRaytheon Corporate Jets HAWKER 1000 · S/N 259048N6194DCessna 172N · S/N 17272626N652CEshleman Charles L AVID FLYER MARK IV · S/N 1158DN71JBCirrus Design SR22T · S/N 8838N8181NPiper PA-28-140 · S/N 28-25377N83TXLangerud/Taylor/Hines PITTS S1E · S/N 8-0110N84AJPa-18 AC-18-CUB · S/N AC-18-001N85AJCessna A185F · S/N 18503424N868WUBritish Aerospace BAE 125 SERIES 1000A · S/N 259017
Back to South Portland, ME