OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,231

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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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.

N1554BPingston Robert D · Morrice, MIBuilt 1948 · S/N 6181N1555BLee Robert E · Medford, WIBuilt 1948 · S/N 6182N1558BMetz Erik C · Ottsville, PABuilt 1948 · S/N 6185N1559BBeierle Michael · Hanover Township, PABuilt 1948 · S/N 6186N1559EThornton Brothers Inc · Lincoln, MEBuilt 1946 · S/N 7AC-5122N1559NJohnston Samuel P · Spring Grove, ILS/N 23091N155VWolcott Guy R II · Gresham, ORBuilt 1952 · S/N 20949N1560BJackson David Clark · Penn Yan, NYBuilt 1948 · S/N 6187N1561QWhisper Jet Aviation LLC · Scottsdale, AZS/N 15072861N1561YFire Hound LLC · Springfield, ORBuilt 1962 · S/N 17249261N1562EStenson Ryan M · Newton, NHS/N 7AC-5125N1562QFrontjes Richard J · Essexville, MIBuilt 1971 · S/N 15072862N1562YWalker Karl L · Las Vegas, NVBuilt 1962 · S/N 17249262N1563YCraik James E · Trout Creek, MTBuilt 1962 · S/N 17249263N1564YBurkes Mark E · Denison, TXBuilt 1962 · S/N 17249264N1566QMexico Missions & Beyond Inc · Harrison, TNS/N 15072866N1569BLedwith Kenneth E · Lincoln, CABuilt 1948 · S/N 6196N1569YPropp William D · Azle, TXBuilt 1962 · S/N 17249269N156DARound Trip Lc · Elkhart, KSS/N 15079190N156DFHumphrey Gene E · Hawkins, TXBuilt 2008 · S/N 650-106N156KAXclusive Level Auto Glass LLC · Kissimmee, FLBuilt 1973 · S/N 15074980N156LBlackbird Cain J · Orange, MABuilt 1998 · S/N 3206N1570QColvin William E · Newberry, FLBuilt 1971 · S/N 15072870N1570YBoggs Texe T · Sarcoxie, MOBuilt 1962 · S/N 17249270N1572BGallegos Paul A III · Blackfoot, IDBuilt 1948 · S/N 6199N1572QStenberg Andrea Renee · Edmonds, WAS/N 15072872N1573BWeber Joel A · Goddard, KSBuilt 1948 · S/N 6200N1573QFergeson Matthew C · Dwg, TXBuilt 1971 · S/N 15072873N1574KBryant Tyrone L · Bigfork, MTBuilt 1946 · S/N 4301N1574LNghiem Daniel · Westminster, CABuilt 1973 · S/N A1500460N1574YBlue Hawk LLC · Rogers, MNS/N 17249274N1575QKelley Jack T Jr · Linden, NCS/N 15072875N1576BBennett Robert M · Felton, DEBuilt 1948 · S/N 6203N1577YConner James D · Elgin, TXBuilt 1962 · S/N 17249277N1578QBrown Carolyn J · West Ossipee, NHBuilt 1971 · S/N 15072878N1579QChastain Elizabeth A · Saint Louis, MOBuilt 1971 · S/N 15072879N157ECJones Joseph B · Newport, NCBuilt 2007 · S/N 1017-2007N157EZWay Robert Shamblin · Northport, ALBuilt 2016 · S/N RW1N157JWYau Jay · Torrance, CABuilt 1974 · S/N CAL1N157KAPhillips David Jj · Orlando, FLS/N 15075210N157TCBengtson Todd D · Tyler, TXBuilt 1946 · S/N 1101N1580YG2g Aviation LLC · Wray, COBuilt 1962 · S/N 17249280N1581YHampton Industrial · Jacksonville Beach, FLS/N 17249281N1582EDittlinger Bret W · Anchorage, AKBuilt 1947 · S/N 7AC-5146N1583BColvin Clu D · Big Cabin, OKBuilt 1948 · S/N 6210N1583YR & L Air Service LLC · Yatesville, GABuilt 1962 · S/N 17249283N1585BCoulter James J · Copperopolis, CABuilt 1948 · S/N 6212N1585KMcbride David T · Albuquerque, NMBuilt 1946 · S/N 4312N1585YKovtun Andriy · Elmwood Park, NJBuilt 1962 · S/N 17249285N1587YFry William A · Willmar, MNBuilt 1962 · S/N 17249287
Back to AD 94-05-05 R1