OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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.

N2960UMedford Mark A · Mantua, OHBuilt 1963 · S/N 17250560N2962EPaulisue Aviation LLC · East Saint Louis, ILBuilt 1978 · S/N 17271388N2965UPatterson John R · Leeds, ALBuilt 1963 · S/N 17250565N29664Tyree William B · Arlington, TXBuilt 1974 · S/N 17264119N2967EBme N2967e LLC · Clearwater, FLBuilt 1978 · S/N 17271391N296MEJwl Aviation LLC · San Carlos, CABuilt 2000 · S/N 172S8554N296NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11096N296PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10211N296PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13324N2970ESparrowhawk Aviation · Manvel, TXBuilt 1978 · S/N 17271393N2971UBurchinal Sam · Brookston, TXBuilt 1963 · S/N 17250571N2975UDehay John M · Bynum, TXBuilt 1966 · S/N 17254180N2976UReid Brian M · Boise, IDBuilt 1966 · S/N 17254525N297BBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12962N297CPChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12503N297MET L B Inc · Howell, NJBuilt 2000 · S/N 172S8556N297PEPhoenix East Aviation LLC · Daytona, FLBuilt 2006 · S/N 172S10338N297PLAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13328N297TCMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1997 · S/N 17280016N2981ECox William Warren · Collierville, TNBuilt 1978 · S/N 17271394N2984UJuris Ronald D · Bickleton, WABuilt 1966 · S/N 17255040N2985UConnersville Flying Club Inc · Connersville, INBuilt 1963 · S/N 17250585N2986ULuebke Austin D · Corsica, SDS/N 17250586N2987UMott Charles A Jr · Chesapeake, VABuilt 1963 · S/N 17250587N2988UFrost Eddy L · Bishop, TXS/N 17250588N2989UGodinez Mauricio U · San Diego, CABuilt 1963 · S/N 17250589N298GBSandhu Harpreet · Livermore, CABuilt 1977 · S/N 17268841N298MCJ C B Aircraft Sales And Leasing · Princeton, NJBuilt 1997 · S/N 17280303N298MEVermont Flight Academy Inc · South Burlington, VTBuilt 2000 · S/N 172S8557N298PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10147N298PLTextron Aviation Inc · Wichita, KSS/N 172S13653N298SCCharlie Aviation LLC · Oregon City, ORBuilt 2024 · S/N 172S13241N2990UShiny Pigeon LLC · Fort Worth, TXBuilt 1963 · S/N 17250590N2991UNeary Joseph P · Lindenhurst, ILBuilt 1963 · S/N 17250591N2993U63 Aviation LLC · Petoskey, MIBuilt 1963 · S/N 17250593N2994ESkyventure Aviation LLC · Battle Creek, MIBuilt 1979 · S/N 17271398N2997UWilliams Michael L · Skaneateles, NYBuilt 1963 · S/N 17250597N2999URichmor Aviation Inc · Hudson, NYBuilt 1963 · S/N 17250599N299KJN299kj LLC · Auburn, WABuilt 2016 · S/N 172S11749N299PLTextron Aviation Inc · Wichita, KSS/N 172S13654N29AFDale Michael · Murrieta, CABuilt 1998 · S/N 17280456N29ERCosta Air Service LLC · Painted Post, NYBuilt 1977 · S/N 17269532N29HLSchreiber Christopher · Foley, ALBuilt 1975 · S/N 17266262N29HTTrede 2023 LLC · Aurora, ORBuilt 2024 · S/N 172S13215N29MXPeterson Jim · Bedford, WYBuilt 1975 · S/N 17266309N2FNFlying Neutrons LLC · Lebanon, OHBuilt 1977 · S/N 17269910N2HABrunner Robert L · Jefferson, ORBuilt 1975 · S/N 17265382N2JHReign Air Charter Corp · New Port Richey, FLBuilt 1964 · S/N 17252443N2SKRegistered aircraftBuilt 1980 · S/N 172RG0666N2TPHanchett James R · Cheboygan, MIBuilt 1963 · S/N 17250269
Back to AD 90-06-03 R1