North Andover, MA
Registered aircraft · 31
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 = 'MA' AND g.registrant_city = 'NORTH ANDOVER' 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 = 'MA' AND g.registrant_city = 'NORTH ANDOVER' 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.
N1193VAmerican General Acft AG5B · S/N 10071N13081Cessna 172M · S/N 17262481N131JBCub Crafters CC19-180 · S/N CC19-0020N1327RGrumman American Avn. AA-5 · S/N AA5-0727N1745RCessna A185F · S/N 18502465First renewal noticeN2166LPiper PA-28-181 · S/N 28-7990259N241SZAvia Stroitel AC-5M · S/N 020N2462TCessna 172R · S/N 17280834N2484UCessna 172D · S/N 17250084N252PFCirrus Design SR20 · S/N 8535N2624NRobinson Helicopter R22 BETA · S/N 0739N2670MBeech F33A · S/N CE-1082N2673ZCessna 185C · S/N 185-0673N337CLDiamond Aircraft Ind DA20-C1 · S/N C0037N34235Cessna 177B · S/N 17701726N35383Cessna 172I · S/N 17256743N3750JCessna 150G · S/N 15065050N380XCessna 177RG · S/N 177RG0751N456ASDiamond Aircraft Ind DA 40 · S/N 40.456N4690NCessna 182Q · S/N 18267289N56DGCessna 172M · S/N 17266239N58053Piper J3C-65 · S/N 8082N644RARobinson Helicopter R44 · S/N 2205N6470RPiper PA-28-140 · S/N 28-21658N6BGCirrus Design SR22 · S/N 5090N707JGGrumman American Avn. AA-5B · S/N AA5B0607Registration pendingN72878Cessna 140 · S/N 10072N736YBCessna R172K · S/N R1722884N757WTCessna TR182 · S/N R18201230N8466XCessna 172C · S/N 17248966N960VTCompagnie Daher TBM 700 · S/N 1600
Back to North Andover, MA