# Registered aircraft: Hudson, MA

A list on [Hudson, MA](https://openairdocs.org/faa-place/MA/Hudson.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N156FC](https://openairdocs.org/aircraft/N156FC.md): Fieseler FI-156-C1 · S/N 4621 · Collings Foundation Inc DBA
- [N1914C](https://openairdocs.org/aircraft/N1914C.md): Curtiss Aeroplane F 100 · S/N 219 · Built 1914 · Collings Foundation Inc DBA
- [N2103F](https://openairdocs.org/aircraft/N2103F.md): Balloon Works FIREFLY 7 · S/N 748 · Built 1976 · Givler James B
- [N259SR](https://openairdocs.org/aircraft/N259SR.md): Cirrus Design SR20 · S/N 1749 · Built 2006 · Ju87 LLC
- [N284CF](https://openairdocs.org/aircraft/N284CF.md): Curtiss Wright P-40B · S/N 16073 · Built 1941 · Collings Foundation Inc DBA
- [N29324](https://openairdocs.org/aircraft/N29324.md): Waco UPF-7 · S/N 5351 · Built 1940 · Collings Foundation Inc DBA
- [N39EW](https://openairdocs.org/aircraft/N39EW.md): Eurocopter AS 350 B3 · S/N 3570 · Built 2002 · Tuckamore Aviation Corp
- [N4503B](https://openairdocs.org/aircraft/N4503B.md): North American AT-6F · S/N 121-42583 · Built 1944 · Collings Foundation Inc DBA
- [N45649](https://openairdocs.org/aircraft/N45649.md): Cessna 150M · S/N 15077006 · Built 1975 · Cygan Fred P
- [N4621](https://openairdocs.org/aircraft/N4621.md): North American OV-10A · S/N 67-14621 · Collings Foundation Inc DBA
- [N502SP](https://openairdocs.org/aircraft/N502SP.md): Hopkins T Eric SPORTSMAN GS-2 · S/N 7306 · Built 2009 · Airon Aviation LLC
- [N576CF](https://openairdocs.org/aircraft/N576CF.md): Ilyushin IL-2 · S/N 1878576 · Ju87 LLC
- [N64SQ](https://openairdocs.org/aircraft/N64SQ.md): Vickers Supermarine SPITFIRE MK.F IX · S/N 6S-160931 · Built 1942 · Collings Foundation Inc DBA
- [N6HS](https://openairdocs.org/aircraft/N6HS.md): Cessna T-50 · S/N 3696 · Built 1942 · Collings Foundation Inc DBA
- [N707CF](https://openairdocs.org/aircraft/N707CF.md): Ilyushin IL-2 · S/N 1870710 · Ju87 LLC
- [N717AR](https://openairdocs.org/aircraft/N717AR.md): Piper PA-28-180 · S/N 28-1411 · Built 1963 · Jones Joshua W
- [N71SQ](https://openairdocs.org/aircraft/N71SQ.md): Hawker Siddeley HURRICANE MKX11 · S/N 5481 · Built 1943 · American Heritage Museum
- [N82PM](https://openairdocs.org/aircraft/N82PM.md): Grumman American Avn. AA-5B · S/N AA5B-0250 · Built 1976 · Collings Foundation Inc
- [N963AC](https://openairdocs.org/aircraft/N963AC.md): Cessna 172S · S/N 172S8259 · Built 1999 · Young Paul J
- [N985R](https://openairdocs.org/aircraft/N985R.md): Grumman G-21A · S/N B-86 · Built 1951 · Collings Foundation Inc DBA

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'HUDSON'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/MA/Hudson/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
