Skip to content

Registered aircraft · 21

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 ('0420722')
  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 ('0420722')
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.

N1659ZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1949 · S/N 5021 N25LKrall James M · Mitchell, SDS/N 5025 N3973CRegistration Pending · Independence, ORRegistration pendingBuilt 1953 · S/N 5040 N415GWebber Gregory W · Nyssa, ORBuilt 1949 · S/N 5052 N611PColton Richard F · Grants Pass, ORS/N 5075 N94403Mcgee Danny P · S Prince Geo, VABuilt 1949 · S/N 5035 N94411Sale Reported · Evansville, INSale reportedBuilt 1950 · S/N 5069 N94426Battie Kenneth L · Seattle, WAS/N 5060 N94427Ericson Eric · St Charles, ILS/N 5073 N94428Ross William P · Brighton, MIBuilt 1950 · S/N 5074 N94431Byrne Matthew A · West Allis, WIBuilt 1950 · S/N 5077 N94438Gassert Kevin J · Cincinnati, OHS/N 5008 N94765Demarzo Alexander · Flower Mound, TXBuilt 1949 · S/N 5031 N9485KGregory Vernon L · Swansea, SCBuilt 1949 · S/N 4999 N94881Heusinkveld Karen B · San Marcos, TXBuilt 1950 · S/N 5067 N94886Walker Stephen L Trustee · Andover, KSBuilt 1949 · S/N 5014 N94887Moore Gary Trustee · Hillsboro, OHBuilt 1949 · S/N 5015 N94889Springer Thomas W · Gulf Breeze, FLS/N 5017 N94890Yeates Rebecca A · San Angelo, TXBuilt 1949 · S/N 5018 N94894Chappie Michael R · Sidney, OHBuilt 1949 · S/N 5022 N94898Gorham Raymond A · Lock Haven, PABuilt 1949 · S/N 5026

Back to Ercoupe G