Nantucket, MA
Registered aircraft · 50
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 = 'NANTUCKET' 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 = 'NANTUCKET' 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.
N13680Cessna 172M · S/N 17262937N1815GBeech V35B · S/N D-10379N184SBHersha Scott C RV-8 · S/N 82661N185KMCessna A185F · S/N 18502451N208BKCessna 208B · S/N 208B1190N222RZBeech 58 · S/N TH-857N222VBRobinson Helicopter R44 II · S/N 10009N225SMGary L Burch RV-8 · S/N 83164N226BGCirrus Design SR22 · S/N 0837N2292KBeech 3N · S/N CA-8N2657GCessna 421C · S/N 421C0809N2TZCirrus Design SF50 · S/N 0083N331ELRobinson Helicopter R44 II · S/N 14667N332RMCirrus Design SR22T · S/N 1986N36GRCessna 172N · S/N 17272026N395CDCirrus Design SR22 · S/N 1263N402BKCessna 402C · S/N 402C0689N406BKCessna 402C · S/N 402C0807N40748Piper J3C-65 · S/N 7463N41VKBeech A36 · S/N E-1885N42AACessna 402C · S/N 402C0238N4344ZPiper PA-18-150 · S/N 18-8662N461BCBeech 58 · S/N TH-1661N4633SCessna TR182 · S/N R18201363N499DTEmbraer Executive EMB-505 · S/N 50500844N51906Boeing A75N1(PT17) · S/N 75-2517N599ZZMaule MX-7-180C · S/N 28026CN606ZZPiper PA46R-350T · S/N 4692062N6169RCessna 172RG · S/N 172RG0102N6436DNorth American SNJ-5 · S/N 88-16388N7304TCessna R182 · S/N R18200027N7417TCessna 172A · S/N 47017N758DWCessna R172K · S/N R1723022N79514Cessna 172N · S/N 17268134N826SPCessna 172S · S/N 172S8739N8281YPiper PA-32-301 · S/N 328106003N87HUAviat A-1C-180 · S/N 3287N883JPCirrus Design SR22 · S/N 0363N89STextron T206H · S/N T20609524N90566Clemons & Berry CUBY · S/N 621N920BECessna 152 · S/N 15283538N9362JPiper PA-28-180 · S/N 28-3461N946EDTextron 208B · S/N 208B5747N955PLTextron 208B · S/N 208B5753N960MDCompagnie Daher TBM 700 · S/N 1490N982GABeech 200 · S/N BB-149N98GFCirrus Design SF50 · S/N 0194N99887Cessna T182T · S/N T18208751N999GKPiper PA-31-350 · S/N 31-8152101N9DTTruax F Dean EUROPA TRI-GEAR · S/N A-182
Back to Nantucket, MA