OpenAirDocs.org
Saipan, MP

Registered aircraft · 18

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 = 'MP' AND g.registrant_city = 'SAIPAN'
  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.

N108JLPiper PA-31-350 · S/N 31-8352028Built 1983 · Star Marianas Aviation School IncN148RVWaco Classic YMF-F5C · S/N F5C-8-152Built 2018 · Waco-1 LLCN16542Piper PA-32-300 · S/N 32-7340093Marianas Air Transfer IncN244CJGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-17-239Built 2017 · Paula Stewart LLCN255AVGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-15-215Built 2015 · Paula Stewart LLCN27TPTextron 172S · S/N 172S11690Built 2016 · Tandem Skydive Saipan IncN4127RPiper PA-32-300 · S/N 32-40445Built 1968 · Star Marianas Air IncN4238RPiper PA-32-300 · S/N 32-40603Built 1969 · Marianas Air Transfer IncN4254RPiper PA-32-300 · S/N 32-40625Built 1969 · Star Marianas Air IncN4437XPiper PA-28-140 · S/N 28-7625032Built 1975 · Marianas Air Transfer IncN4599XPiper PA-32-300 · S/N 32-7640040Built 1975 · Star Marianas Air IncN5245VCessna 172RG · S/N 172RG0482Built 1980 · Marianas Air Transfer IncN6733FPiper PA-28-140 · S/N 28-7725077Marianas Air Transfer IncN733GXCessna 172N · S/N 17268294Built 1976 · Marianas Air Transfer IncN829JPCessna 208B · S/N 208B2429Built 2013 · Micronesian Air Cargo Services (Cnmi) LLCN9000MPiper PA-32-300 · S/N 32-7240053Built 1971 · Saipan Transportation Management Solutions IncN910BSTextron 208B · S/N 208B5850Built 2025 · 5836 (Cnmi) LLCN9337ECessna 172N · S/N 17272230Built 1979 · Marianas Air Transfer Inc
Back to Saipan, MP