OpenAirDocs.org
AD 47-13-02

Registered aircraft · 1,237

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-13-02')
    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-13-02')
  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 2868N175JBWhitcher Garrick L · Woodburn, ORS/N 1607N1938BKing Richard S · San Antonio, TXBuilt 1938 · S/N 1101N1941XNezgoda 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 6719N20415Haas Larry W · La Cygne, KSBuilt 1938 · S/N 1103N20VHale Leland Wayne Jr · Van Alstyne, TXBuilt 1946 · S/N 7891N21223Colvin Clu DBA · Big Cabin, OKBuilt 1938 · S/N 1013N21229Johnk Willi C · Donalds, SCBuilt 1938 · S/N 1019N21235Humphrey Andrew D · Johnstown, OHBuilt 1938 · S/N 1025N21239Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N 1029N21253Brightwell W Stephen · Cincinnati, OHBuilt 1938 · S/N 1045N22207Carr Leon C · Moody, TXBuilt 1939 · S/N 1145N22291Vandemark Raymond L · Ithaca, NYBuilt 1939 · S/N 1241N22296Yurechko Philip Jr · Jewett City, CTBuilt 1955 · S/N 1256N22616Lakeland Aero Club Inc · Lakeland, FLBuilt 1939 · S/N 1264N22618Yeater Jason S · Upper Sandusky, OHBuilt 1940 · S/N 1266N22646Lubak Lawrence E · Chino Hills, CABuilt 1939 · S/N 1293N22652Brack Robert L M · Ocqueoc, MIS/N 1299N22668Lidd Mark L · Vienna, VABuilt 1939 · S/N 1315N2273NHakala Merril W · Dayton, ORBuilt 1939 · S/N 1713N23619Miller Darrell Y · Madras, ORS/N 1344N23632Retka David L · St Paul, MNBuilt 1939 · S/N 1340N23638Candlish John B · RoggwilNon-citizen corporation, flight hours not reportedBuilt 1939 · S/N 1368N23668Stuckle Eugene A · Davenport, WABuilt 1939 · S/N 1399N23679Sieverding Wayne A · Dundee, MNBuilt 1939 · S/N 1413N23688Darling Steven M · Decatur, INBuilt 1939 · S/N 1422N23690Mason Michael L · Santa Paula, CABuilt 1939 · S/N 1424N23694Rodriguez Charles L · Murphysboro, ILBuilt 1939 · S/N 1428N23812Wenzel David R · Rudd, IABuilt 1939 · S/N 1446N23825Stoos Robert A · Lakeland, FLS/N 1461N23835Spring Jack B · Kentwood, LAS/N 1471N23876King Andrew D · Vienna, VABuilt 1939 · S/N 1512N23880Hustak Michael G Jr · Granbury, TXBuilt 1946 · S/N 7682N23884Poorman Gary L · Liberty Center, OHBuilt 1939 · S/N 1520N23888Mcguire Christopher · Claremore, OKBuilt 1939 · S/N 1524N23892Tally Ho 609 LLC · Avon Lake, OHBuilt 1939 · S/N 1527N23898Lake Seth J · Russellville, ARBuilt 1939 · S/N 1533N24031Chambers John O · Sheridan, WYBuilt 1939 · S/N 1566N24032Emerson Dean S · Denison, TXS/N 1567N24035Wood Stephen K · Whitewater, COBuilt 1939 · S/N 1570
Back to AD 47-13-02