Skip to content

Registered aircraft · 394

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

N3398KStahl Brad · Jackson, CAS/N 1391 N33TCAviation Safety Services And Management LLC · Grapevine, TXBuilt 1946 · S/N 2106 N347Haugen Michael C · Oklahoma City, OKFirst renewal noticeBuilt 1946 · S/N 2091 N369BZBartholomew Don · Gardnerville, NVBuilt 1946 · S/N 1302 N3704KWilson Stephen A · Granbury, TXBuilt 1946 · S/N 1397 N3707KGoodman Steven L · Phoenix, AZBuilt 1946 · S/N 1400 N3709KPlane Fun Inc Tr Trustee · Snellville, GAS/N 1402 N3712KPatton Charles R · New Bern, NCBuilt 1946 · S/N 1405 N3717KVetter Virgil R · Plattsburg, MOBuilt 1946 · S/N 1410 N3719KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 1412 N3720KGreen Mark · Killeen, TXS/N 1413 N3723KMiller Charles · Bynum, TXS/N 1416 N3725KWalters Jeffrey D · Morganton, NCBuilt 1946 · S/N 1418 N3727KFussell L J · Broxton, GABuilt 1946 · S/N 1420 N3729KRoth Steven C · The Villages, FLBuilt 1946 · S/N 1422 N3731KDicker Alan J · Scottsdale, AZBuilt 1946 · S/N 1424 N3735KHarris George P · Pine, COBuilt 1946 · S/N 1428 N3740KWilliamson Ronald W · Westlake Village, CABuilt 1946 · S/N 1433 N3741KFratti Robert B · Nampa, IDBuilt 1946 · S/N 1434 N3748KDuffus Andrew · Renton, WABuilt 1946 · S/N 1441 N3749KMorley Richard G · Indian Rocks Beach, FLBuilt 1946 · S/N 1442 N3755KRegistration Pending · Carlsbad, CARegistration pendingS/N 1448 N3756KStottlemyer Bradley J · Lake Geneva, WIBuilt 1946 · S/N 1449 N3760KPavlinovic Lawrence E · Lake Stevens, WABuilt 1946 · S/N 1453 N3762KKawasaki Clyde H · Carson City, NVS/N 1455 N3764KAnderson Ricky P · Dodge, TXS/N 1457 N3770KBalint Jozef · Fort Worth, TXS/N 1463 N3772KSale Reported · Crestline, CASale reportedBuilt 1946 · S/N 1465 N3773KHansen Ernest F · Sequim, WABuilt 1946 · S/N 1466 N3782KRegistered aircraftBuilt 1946 · S/N 1475 N3783KAndrews Nathan S · Graham, WABuilt 1946 · S/N 1474 N3787KStearns Edwin Ben Jr · Chandler, AZS/N 1480 N3788KSwift Museum Foundation Inc · Athens, TNBuilt 1946 · S/N 1481 N3796KFletcher Larry · Fairhope, ALBuilt 1946 · S/N 1489 N3801KLanier John M · Reidsville, NCBuilt 1946 · S/N 1494 N3802KService Air Corps · Dallas, TXBuilt 1946 · S/N 1495 N3805KAndersen Allen E · Las Vegas, NVS/N 1498 N3808KBartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 1501 N3810KFiser Richard L · Palmer Lake, COBuilt 1946 · S/N 1503 N3834KVanderbeek Robert K · Plainfield, ILBuilt 1947 · S/N 1527 N3847KMcdevitt Daniel C · Social Circle, GABuilt 1948 · S/N 3547 N3852KBartholomew Don · Gardnerville, NVBuilt 1948 · S/N 3552 N3854KHyland David N · Fall Creek, ORBuilt 1948 · S/N 3554 N3878KQualitair LLC Trustee · MichelstadtBuilt 1948 · S/N 3578 N3886KHilliard Jack M · Knoxville, TNBuilt 1948 · S/N 3586 N3887KWaters Joseph P · Morganton, NCBuilt 1948 · S/N 3587 N3890KClark David L · Arlington, TXBuilt 1946 · S/N 1283 N39LMPhillips William R · Cullman, ALBuilt 1946 · S/N 101 N4487ZWigley David A · Lake Grove, NYBuilt 1946 · S/N 346 N46GSSilcox Brian · Gig Harbor, WABuilt 1946 · S/N 1172

Back to Globe GC-1B