OpenAirDocs.org
AD 47-16-03

Registered aircraft · 1,566

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:47-16-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:47-16-03')
  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.

N1023DGregg John I Jr · Glendale, AZS/N 10520N10JLSmith Loren D · Great Falls, MTBuilt 1946 · S/N 6681N1182KUllrich Sandy J · Haskell, OKS/N 8309N121BXEnglish Dexter · Syracuse, KSS/N 8960N128ZKammer Frank B · Ringgold, GAS/N 7149N1510TRegistered aircraftAssigned, pending cancellationS/N 2868N17226Eaa Chapter 1077 · New Philadelphia, OHBuilt 1939 · S/N 1892N175JBWhitcher Garrick L · Woodburn, ORS/N 1607N1935Cavanaugh Darrel N · Wasilla, AKBuilt 1940 · S/N 1935N1938BKing Richard S · San Antonio, TXBuilt 1938 · S/N 1101N1939TDickhudt Gene R · Mcpherson, KSBuilt 1940 · S/N 1870N1941XNezgoda Daniel A Jr · Las Vegas, NVS/N 2558N19461Bouchard Jason A · Carmel Valley, CAS/N 9820N194KJCollins Richard F · Lake Wales, FLBuilt 1948 · S/N 12010N1951JDelaney John D · Mineral Point, WIBuilt 1946 · S/N 9902N197HKaspar Russell B · Frankfort, INBuilt 1941 · S/N 2915N19JLPodeweltz Dana A · Merrill, WIBuilt 1946 · S/N 6719N20414Clark James R · Rhome, TXBuilt 1938 · S/N 1102N20415Haas Larry W · La Cygne, KSBuilt 1938 · S/N 1103N20442Young Thomas E · Smithsburg, MDBuilt 1939 · S/N 1130N20447Jensen James A · Palo, IABuilt 1939 · S/N 1135N20VHale Leland Wayne Jr · Van Alstyne, TXBuilt 1946 · S/N 7891N21222Timothy J Glidden · Millinocket, MEBuilt 1938 · S/N 1012N21223Colvin Clu DBA · Big Cabin, OKBuilt 1938 · S/N 1013N21226Mcfarlane Donald · Turlock, CABuilt 1938 · S/N 1016N21229Johnk Willi C · Donalds, SCBuilt 1938 · S/N 1019N21232Withrow Thomas E · Lewisburg, WVBuilt 1938 · S/N 1021N21235Humphrey Andrew D · Johnstown, OHBuilt 1938 · S/N 1025N21239Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N 1029N21250Boggs Ricky L · London, OHS/N 1043N21253Brightwell W Stephen · Cincinnati, OHBuilt 1938 · S/N 1045N21255Wright Attitudes Inc · Taft, TNBuilt 1938 · S/N 1047N21261Whitaker David E · Canton, OHBuilt 1938 · S/N 1054N21282Turner Dave K · Angleton, TXBuilt 1938 · S/N 1075N21287Maule Susan D · Media, PAS/N 1081N21293Johnson Steven D · Oklahoma City, OKBuilt 1938 · S/N 1087N21296Witbeck Gerald B · Clare, MIBuilt 1938 · S/N 1093N22207Carr Leon C · Moody, TXBuilt 1939 · S/N 1145N22211Neely James B · Kane, PABuilt 1939 · S/N 1149N22216Seal Jerry W · Westlake, LAS/N 1154N22220Frost Beverly J · Greenfield, INS/N 1160N22227Withrow Thomas E · Lewisburg, WVS/N 1173N22228Brown Edward A · Halifax, MAS/N 1174N22233Burton Leslie L Jr · Mt Juliet, TNBuilt 1939 · S/N 1179N22235Perdue Sandy L · Asheboro, NCBuilt 1939 · S/N 1183N22242Johnson Richard W · Lawton, OKS/N 1190N22246Griswold Dean A · Belvidere, ILBuilt 1939 · S/N 1193N22249King Daniel R · Portland, TXBuilt 1939 · S/N 1197N22256Port Townsend Aero Museum · Port Townsend, WABuilt 1939 · S/N 1204N22257Colson Carl · Blunt, SDS/N 1205
Back to AD 47-16-03