OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N3777PSkatvold Charles P · Moorhead, MNBuilt 1959 · S/N 18-4665N3777TStewart Donald J · Palm City, FLBuilt 1967 · S/N 28R-30089N3777ZAnderson Clarence Trustee · Anchorage, AKS/N 18-7459N3778TVan De Vanter Robert A · Paso Robles, CAS/N 28R-30090N3778XChang Tim C · Ocala, FLFirst renewal noticeBuilt 1968 · S/N 271N3778ZWard Nelson H · Salcha, AKBuilt 1960 · S/N 18-7460N37790Cottrell Mark C · Leitchfield, KYBuilt 1982 · S/N RHM-1N3779AForte Angelo L · Franklinville, NJBuilt 1953 · S/N 22-2021N3779NObrien Edward Trustee · Walnut Creek, CAS/N 680116N3779TShultz Martin · Naperville, ILBuilt 1967 · S/N 28R-30091N3779ZNace Kris A · Glendale, ORBuilt 1960 · S/N 18-7461N377BFountain Acquisitions LLC · Mount Vernon, GAS/N TD-69N377BAHolliday Richard A · Fort Worth, TXBuilt 1977 · S/N 177RG1245N377BMQuebec Helicopter LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1691MN377CBBradley Charles A · Gibsonia, PAS/N 24980N377CPHodgson Jeffrey R · Watsonville, CAFirst renewal noticeBuilt 2010 · S/N 70377N377CZKramer Dean E · Bernville, PABuilt 1960 · S/N 18-7448N377DSSeward Bernard L Jr · Charlottesville, VABuilt 2003 · S/N 40.277N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086N377HGHunt James J · Dalton, PABuilt 1998 · S/N 1252-98N377HHJennings Christopher Wyckoff Trustee · Brentwood, TNBuilt 1970 · S/N 39-13N377HLLatshaw Hunter W · Mount Holly, NCBuilt 2007 · S/N 71854N377JDStyer David · Milton Freewater, ORS/N 2007N377KGGardetto Paul R · Oconomowoc, WIBuilt 2014 · S/N 73266N377LDJohnson Harvey P · Roseau, MNBuilt 2008 · S/N 72140N377LMOliver Gerald D III · Midlothian, TXBuilt 2008 · S/N 648N377THMenard Keith L · Bellevue, TXS/N 3284N37809Cavanagh Michael B · Dubois, WYBuilt 1983 · S/N 004N3780MRegistration Pending · Cody, WYRegistration pendingBuilt 1947 · S/N 12-2710N3780TBowley Leonard · Newton, ALBuilt 1967 · S/N 28R-30092N3780ZBenoit Robert W · Hot Springs, ARS/N 18-7462N3781KBomar Tami J · Gig Harbor, WABuilt 1967 · S/N 28-23728N3781LCarmel Aviation Inc · Boise, IDBuilt 1965 · S/N 17253950N3781PHoogendorn Homer E · Wasilla, AKFirst renewal noticeBuilt 1955 · S/N 18-4671N3781XN3781x LLC · Puyallup, WABuilt 1968 · S/N 275N3781YPhillips Holly N · Reed Point, MTBuilt 1960 · S/N 18-7463N3782MMills Air Service Inc · Marstons Mills, MAS/N 12-2712N3782RFreeman William B Jr · Southington, CTBuilt 1970 · S/N 28-5824N3782XBrown David L · Flemington, WVBuilt 1968 · S/N 276N3782ZJordan S G · Wasilla, AKBuilt 1960 · S/N 18-7466N3783PMcdaniel Robert M · Tonasket, WAS/N 18-4678N3783ZSchulz Kevin J · Clearlake Park, CABuilt 1960 · S/N 18-7467N3784BOgorek Peter J · Milwaukee, WIBuilt 1955 · S/N CH-200N3784KBurr Walter E · Tecumseh, MIBuilt 1967 · S/N 28-23729N3784MGtf Aviation LLC · Fryeburg, MEBuilt 1947 · S/N 12-2714N3784NMorcott Ian · Mountain Home, IDBuilt 1967 · S/N 680118N37853Stack Edward Jr · Naperville, ILBuilt 1941 · S/N 1000N37856Siemens Daniel D · Ben Wheeler, TXBuilt 1941 · S/N 1003N3785MSale Reported · Stanton, MNSale reportedBuilt 1947 · S/N 12-2554N3785TZeuner John F · Austin, TXBuilt 1967 · S/N 28R-30098
Back to AD 90-04-06 R1