Stow, MA
Registered aircraft · 48
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 = 'STOW' 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 = 'STOW' 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.
N109EVMesserschmitt ME 109 G · S/N 610937N12ZEAlakai Technologies SKAI · S/N 1596F350457791151184N13408Waco UIC · S/N 3767N157RFChampion 7GCAA · S/N 108N18192Monocoupe 90AF · S/N A-821N188RHDouglas EA-1E · S/N 135188N20390Cessna 172M · S/N 17261250N207EVBoeing B-17G · S/N 44-83785N224JConsolidated Aircraft/Hill B-24J · S/N 44-44052N262AZClassic Fighter Industries ME 262 REPRODUCTION · S/N 501241N26AZNorth American F-100F · S/N 56-3844N2714CCirrus Design SR22 · S/N 1393N293FRCurtiss/Whittington Bros P-40N · S/N 42-104721N3206JBeech B36TC · S/N EA-568N3258Dehavilland DHM-1 · S/N ET4N3433Lane/Bleriot XI AM II · S/N 3N3476GNorth American B-25N · S/N 44-28932N40986Piper J5B · S/N 5-1220N447XSPipistrel Lsa S R L VIRUS SW · S/N 383VSW100LSAN450URBoeing E75 · S/N 75-5300N459CFConsolidated Vultee PBY-5A · S/N 300N459SHHylio HYL-150 · S/N 17906110423Sale reportedN45NLChance Vought/Hill L Clarke F4U-5NL · S/N 124692CN4607VNorth American A36A · S/N 15956N505MHLockheed P-38L · S/N 197425-501N514AVBeech F33A · S/N CE846N524CFMcdonnell Douglas TA-4J · S/N 153524N55171Boeing A75N1(PT17) · S/N 75-3745N6233GBeech A36 · S/N E-1984N648Lockheed T-33A · S/N 51-6953N663ZEAlakai Technologies AH2-1 SKAI · S/N 1596F350457791140583N686SRBaker Dennis L SKYRANGER · S/N 3001N7258HPiper J3C-65 · S/N 21056N725FRBoeing A75 · S/N 75-384N749CFMcdonnell Douglas F4D · S/N 65-0749N7957ECessna 150 · S/N 17757N8036EDouglas B-26B · S/N 44-35696NN89069Cessna 140 · S/N 8073N8962PPiper PA-24-260 · S/N 24-4419N911KKBell UH-1E · S/N 153762N912UBSkyranger Owners Group SKYRANGER NYNJA · S/N 22090358N91FWFocke-Wulf FW-190A4 · S/N 931862N93012Boeing B-17G · S/N 32264N9351QBeech F33A · S/N CE-351N9590ZGrumman TBM-3E · S/N 91733N983CFConsolidated Vultee PBY-5A · S/N 9830N9871FDehavilland MARK 34A · S/N 983157N99253Cessna 172P · S/N 17276421
Back to Stow, MA