OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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-06-03-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-06-03-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.

N9347TLewis University · Romeoville, ILBuilt 2012 · S/N 172S11166N9348FDirty Side Down Aviation LLC · Georgetown, TXBuilt 1997 · S/N 17280189N9348HDeshazer Bill G · Gladewater, TXBuilt 1975 · S/N 17266106N934AZN934az LLC · Miami, FLBuilt 1999 · S/N 172S8294N934EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12982N934GRGrossman Robert W · Andover, MABuilt 1977 · S/N 17269688N934MT8th Dimension Enterprises LLC · Englewood, COBuilt 1997 · S/N 17280058N934TRAris Leasing Inc · Sunnyvale, CABuilt 1977 · S/N 17269190N9351DJennings David M · Huffman, TXBuilt 1982 · S/N 172RG1130N9351HBrown Daniel Thomas · Layton, UTS/N 17266109N9353DRegistration Pending · Simi Valley, CARegistration pending, canceledBuilt 1982 · S/N 172RG1131N9356HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266113N9358ELechmanski Philip J · Shelter Island, NYBuilt 1979 · S/N 17272236N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546N9359HWarren Flying Club · Troy, MIBuilt 1975 · S/N 17266115N935PTTailspin Tommys Inc · Port Townsend, WABuilt 1974 · S/N 17263040N935SCLima Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12475N9362MRegistered aircraftBuilt 2012 · S/N 172S11195N9365HAugusta Aviation Inc · Agusta, GABuilt 1975 · S/N 17266118N9366HPowell Jonathan L · Violet Hill, ARS/N 17266119N93673Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11184N9367DMccreery Aviation Co Inc · Mcallen, TXBuilt 1983 · S/N 172RG1139N9367HDeralex Airways LLC · Miami, FLBuilt 1975 · S/N 17266120N936AZN936az LLC · Miami, FLBuilt 1979 · S/N 17272075N936MBBergstrom Aircraft Inc · Pasco, WABuilt 1978 · S/N 17270211N936YTorres Nathanael · Kissimmee, FLFirst renewal noticeBuilt 1961 · S/N 17249029N93707Vertol Systems Co Inc · Destin, FLBuilt 2012 · S/N 172S11159N9370RFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11189N9372HN9372h LLC · Wilmington, DEBuilt 1975 · S/N 17266123N9373FDirty Side Down Aviation LLC · Georgetown, TXBuilt 1997 · S/N 17280160N9376MBeans James B IV · Camas Valley, ORBuilt 1972 · S/N 17260576N9377HAir Advantage Inc · Mount Pleasant, IABuilt 1975 · S/N 17266126N9378DAndden Aviation LLC · Santa Monica, CABuilt 1983 · S/N 172RG1143N9379FAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280764N9379HCitizen Air LLC · Port Angeles, WABuilt 1975 · S/N 17266128N937ASGc Aviation Services-1 LLC · Miamisburg, OHS/N 172RG1178N937DRStratton Michael C · Hermiston, ORBuilt 1997 · S/N 17280217N937EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12985N937SAAdvanced Aviation Group LLC · Frederick, MDBuilt 2003 · S/N 172S9377N9382DN9382d LLC · Wake Forest, NCBuilt 1983 · S/N 172RG1145N9385LFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1986 · S/N 17276548N9387DPrecise Flight LLC · Waukesha, WIBuilt 1984 · S/N 172RG1148N9387HAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1975 · S/N 17266131N9389ELandr One LLC · Bozeman, MTBuilt 1979 · S/N 17272242N9389LL A M Capital Management LLC · Sheridan, WYBuilt 1986 · S/N 17276549N938AZN938az LLC · Miami, FLBuilt 1977 · S/N 17269590N938EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12988N938SAAa-Aero LLC · Lewes, DEBuilt 2003 · S/N 172S9388N9390BUnited States Air Force · Elmendorf Afb, AKBuilt 1981 · S/N 172RG0810N9390EAmerigo Intl LLC · Miami, FLBuilt 1979 · S/N 17272243
Back to AD 90-06-03 R1