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.

N917MAKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 172S8270N917WETaylor William H II · Albuquerque, NMBuilt 1968 · S/N 17256920N917ZXD & S Flyers LLC · Portage, MIS/N 17253276N9180BHolcomb Nicholas A · Yakutat, AKS/N 36780N9180ZKey West Bandit Squadron LLC · Summerland Key, FLS/N 28142N91813Fallbrook Fly Girl LLC · Lakeside, ORBuilt 1973 · S/N 17261515N9181PNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11084N91823Perra John James Trustee · Gardnerville, NVBuilt 1973 · S/N 17261516N9182HMouton Charles · Gladewater, TXBuilt 1975 · S/N 17265997N9185HFlyit LLC · Washougal, WABuilt 1975 · S/N 17265999N91862Aire Services LLC · Barrigada, GUBuilt 1973 · S/N 17261519N9187BEbrahim Ahmed E · Onalaska, TXBuilt 1958 · S/N 36787N9188GAircraft Management Services Inc · Milton, FLBuilt 1979 · S/N 17273625N9189BSale Reported · Litchfield, MNSale reportedBuilt 1958 · S/N 36789N9189HPendergrass Aviation Inc · Demopolis, ALBuilt 1975 · S/N 17266002N918CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8338N918FAWestways Aviation LLC · El Cajon, CABuilt 1981 · S/N 17274981N918PMMathews Roy · Bay Shore, NYBuilt 1980 · S/N 172RG0602N918VAVolatus Aerospace US Corp · Syracuse, NYS/N 17274912N918VPVanderpool Robert W · Red Devil, AKS/N 17266379N918VTChannel Islands Aviation Inc · Camarillo, CAS/N 17275241N9191BE & D Aviation Sales LLC · Sainte Genevieve, MOBuilt 1958 · S/N 36791N91925Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17261524N91934N91934 LLC · Evergreen, COBuilt 2012 · S/N 17281613N91936Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281614N9193BRegistration Pending · Garwood, TXRegistration pendingBuilt 1958 · S/N 36793N9193GMach One Velocity LLC · Macomb Twp, MIBuilt 1979 · S/N 17273626N9193HPrairie Flyers Flying Club · Eudora, KSBuilt 1975 · S/N 17266006N91966Wings Over Texas Holdings LLC · Denton, TXS/N 17281616N9196BPeterson James G · Keller, TXBuilt 1958 · S/N 36796N9196HLaplante Rene J · Bellingham, WABuilt 1975 · S/N 17266008N9196WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281615N91984A-Line LLC · Kent, WABuilt 1973 · S/N 17261532N9198WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281617N91996Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281619N9199BM & H Investment LLC · Montgomery City, MOBuilt 1958 · S/N 36799N9199ZOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281618N919CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8339N919EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12378N919TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 17280843N919TCD & S Aviation LLC · Spring, TXBuilt 2005 · S/N 172S10019N919ZATextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13350N91FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12951N91FSEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280302N91LVWoodfield Terry J · Pearland, TXBuilt 1980 · S/N 172RG0281N91PAHigh Wing Air LLC · Arnold, MOBuilt 1972 · S/N 17260792N91PFSkyline Solutions Inc · Deland, FLBuilt 2006 · S/N 172S10302N91PMRunrich LLC · Newport News, VABuilt 1974 · S/N 17264113N91QSFly Diablo Inc · North Wales, PABuilt 1976 · S/N 17268167N91WAStevens James L · Carrollton, GABuilt 1955 · S/N 28090
Back to AD 90-06-03 R1