Skip to content

Registered aircraft · 18

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('5650208')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('5650208')
ORDER BY 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.

N26466Burwell Jeff S · Grand Island, NEBuilt 1940 · S/N 19 N26476Wheeler Jeffrey A · Elyria, OHBuilt 1941 · S/N 29 N26488Barg Michael D · Honea Path, SCBuilt 1941 · S/N 41 N26490Gutherie Deborah B Personal Representative · Worton, MDBuilt 1941 · S/N 43 N34307Trek Aviation LLC · Amsterdam, NYBuilt 1941 · S/N 51 N34312Phillips Dale J · Michigan City, INBuilt 1941 · S/N 56 N34317Grasshopper Aviation Inc · Geneseo, NYBuilt 1942 · S/N 61 N34321Griffin Terry M · Bridgeton, NJS/N 65 N34324Haldeman Enterprises LLC · Vancouver, WABuilt 1942 · S/N 69 N34334Arkawy Alan D · Fishkill, NYBuilt 1942 · S/N 79 N34336Warden Richard L · Canby, ORBuilt 1942 · S/N 81 N34341Jasper Ralph Lane · Diberville, MSBuilt 1943 · S/N 86 N34347Barg Michael D · Honea Path, SCBuilt 1943 · S/N 91 N34349Nebraska Antique Airplane Preservation Inc · Wynot, NEBuilt 1943 · S/N 93 N34350Vierhus Steven C · Fresno, CABuilt 1943 · S/N 94 N34351Platten Francis Douglas · Port Angeles, WABuilt 1943 · S/N 95 N34355Kropp Richard G · North Creek, NYBuilt 1943 · S/N 99 N34356Ingle Samuel C · Geneva, OHBuilt 1943 · S/N 101

Back to Meyers OTW-160