Bangor, ME
Registered aircraft · 54
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 = 'BANGOR' 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 = 'BANGOR' 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.
N1046YCanadian Car & Foundry HARVARD MK IV · S/N CCF-4-211N1190BAmerican General Acft AG5B · S/N 10003N11FEGrumman FM-2 · S/N 5734N135ACessna 185E · S/N 185-0986N13WWCessna A185F · S/N 18504378N140WHCessna 650 · S/N 650-0195N157MECessna 172S · S/N 172S8436N1652PPiper PA-18A-135 · S/N 18-3767N17XKClassic WACO YMF · S/N F5C-048N2124XYakovlev/Haley YAK-11 · S/N 102146N232TMaule MX-7-235 · S/N 10021CN2380VCessna 140 · S/N 14618N2413YCessna 172D · S/N 17249713Registration pendingN2423ACessna A185F · S/N 18504225N2433ECessna 206H · S/N 20608136N24BGBeech B200 · S/N BB-1045N2720XCessna 180H · S/N 18051520N279THBell 206L-3 · S/N 51176N3374SCessna 210J · S/N 21059174N34845Cessna 177B · S/N 17702039N415TTCessna 208B · S/N 208B0365N45699Cessna 150M · S/N 15077025N48HHBell 206B · S/N 3620N52175Cessna 180J · S/N 18052538Sale reportedN521BCRainbow Skyreach BUSHCAT · S/N CH185CN52218Cessna 172P · S/N 17274442N5545CCessna 170A · S/N 19598N584CStinson 108-3 · S/N 108-3584N58BVCessna T206H · S/N T20608036N593STCessna 172P · S/N 17276454N600FASmith AEROSTAR 600 · S/N 60-0246-101N600TGCessna 208B · S/N 208B0363N610LACessna 208B · S/N 208B1060N6136VBeech S35 · S/N D-7788N64325Cessna 172P · S/N 17275545N64SLAmerican Legend AL18 · S/N AL-1196N6843XCessna 172A · S/N 47743N728MVTextron 208B · S/N 208B5327N76SCCessna A185F · S/N 18504206N772DWSiai-Marchetti SM 1019 · S/N 007N8045RHughes TH-55 · S/N 64-18084N8699ZCessna P206C · S/N P206-0499N901CMAgusta A109E · S/N 11611N901EMAgusta A109E · S/N 11614N901LFLeonardo AW109SP · S/N 22400N901LMRaytheon B200 · S/N BB-1693N901WMLeonardo AW109SP · S/N 22429N901XMLeonardo AW109SP · S/N 22422N901YMLeonardo AW109SP · S/N 22375N90948Piper PA-18-150 · S/N 18-8109053
Back to Bangor, ME