Skip to content

Registered aircraft · 31

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

N10KSMorris Jerry M · Summerville, SCBuilt 1946 · S/N 388 N131WBrown Jordan Ray · Center Point, INBuilt 1946 · S/N 359 N33336Swift Museum Foundation Inc · Athens, TNBuilt 1945 · S/N 2 N34RXNelson Miguel E · Lake Stevens, WABuilt 1946 · S/N 47 N4303YLopez Richard · Hialeah, FLBuilt 1954 · S/N 235 N5092UZahler Mitchell J · Stillwater, MNS/N 256 N5616TProbst Daniel · Lutz, FLS/N 68 N80501Holliday Mark E · Lake Elmo, MNS/N 4 N80523Riedel David W · Lebanon, OHBuilt 1946 · S/N 26 N80567Barnett Paul S · Brookhaven, MSBuilt 1946 · S/N 70 N80569Samuelian Stephen P · Tehachapi, CAS/N 72 N80573Holliday Mark E · Lake Elmo, MNBuilt 1946 · S/N 76 N80576Putnam George Milton Sidney · Anchorage, AKS/N 79 N80708Hayes Barrett W · Siler City, NCBuilt 1946 · S/N 111 N80723Mahaffey James E · Jackson, MSBuilt 1946 · S/N 126 N80758Zahler Mitchell J · Stillwater, MNBuilt 1946 · S/N 161 N80760Port Townsend Aero Museum · Port Townsend, WABuilt 1946 · S/N 163 N80768Brown Edward J · Graysville, TNS/N 171 N80795Swift Museum Foundation Inc · Athens, TNBuilt 1946 · S/N 198 N80867Diver Simon R · Georgetown, TXBuilt 1946 · S/N 270 N80881Bizzjet Inc · Kalispell, MTBuilt 1946 · S/N 284 N80905Hoover Charles F · Oakdale, MNBuilt 1946 · S/N 308 N89KRholetter Wayne C · Westminster, SCBuilt 1946 · S/N 246 N90302Mendoza Macario · Lancaster, CABuilt 1946 · S/N 316 N90318Nelson Larry Trustee · Almena, KSBuilt 1946 · S/N 332 N90371Jackson Thomas M · Mckinney, TXS/N 385 N90376Hein A Steven · Sedona, AZBuilt 1946 · S/N 390 N90382Richardson Kenneth S · Waterford, MIS/N 396 N90383Hook Kyle B · Petaluma, CABuilt 1946 · S/N 397 N90386Collins Cody W · Palestine, TXS/N 400 N90387Ulmer Bryce · Locust Grove, GABuilt 1946 · S/N 401

Back to Globe GC-1A