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.

N972FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13462N972KCMustang Sally Aviation LLC · Camden, SCBuilt 2000 · S/N 17280972N972NCIal Corp · Lewes, DEBuilt 1971 · S/N 17259818N972PMNp Aviation Inc · Naguabo, PRS/N 17264940N972TAConfluence Systems Consulting · San Jose, CABuilt 2002 · S/N 172S9171N972THUtah State University · Logan, UTBuilt 2023 · S/N 172S12972N972WWChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2002 · S/N 172S9072N9730FN9730f LLC · Boynton Beach, FLS/N 17280032N9730VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264494N97311Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276176N97313Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276177N9731FN9731f LLC · Stuart, FLBuilt 1997 · S/N 17280035N9731HCreative Strategies Inc · Proctorville, OHS/N 17266339N9731TKarren Robert E · Mountain Home, IDS/N 47531N9732HLand & Leave LLC · Helena, MTBuilt 1975 · S/N 17266340N9732VSiguaw Robert E · Deming, WABuilt 1974 · S/N 17264496N9733LStock Craig A · Devon, PABuilt 1986 · S/N 17276604N9733VTyler Ronald J · Martville, NYBuilt 1974 · S/N 17264497N9734BPreston Aviation LLC · Henderson, KYBuilt 1981 · S/N 172RG0999N97358Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276180N9737VAero Equities LLC · Ventura, CABuilt 1975 · S/N 17264499N973BCBattle Creek Flyers LLC · Battle Creek, MIBuilt 1997 · S/N 17280041N973EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13016N973HAAb Prop Plane I LLC · Metairie, LABuilt 2005 · S/N 172S9975N973KGRichard Mervin J Jr · Washington, DCBuilt 1961 · S/N 17248989N9741FAa-Aero Inc · Fairfield, NJBuilt 1997 · S/N 17280036N97428Right Wing Aviation LLC · Fort Wayne, INBuilt 1984 · S/N 17276188N9742BHarp Aviation LLC · Flemington, NJBuilt 1981 · S/N 172RG1005N9743BVinson Paul E DBA · Gainesville, GABuilt 1981 · S/N 172RG1006N9744DTom Wood Aviation Inc · Fishers, INBuilt 1997 · S/N 17280260N97459Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276190N9745TOwens Edward W · Raymore, MOBuilt 1960 · S/N 47545N97465Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276194N9746BRegistration Pending · Middletown, DERegistration pendingBuilt 1981 · S/N 172RG1009N9747TMapes James R · Ellensburg, WABuilt 1960 · S/N 47547N97489Neron II LLC · Lewes, DES/N 17276197N974BCL & W Aircraft Investment LLC · Homestead, FLBuilt 1997 · S/N 17280044N974CAFranks Gary W · Bolivar, MOS/N 17264459N974DBPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10661N974SFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1960 · S/N 17248209N974SPTexas State Technical College · Waco, TXBuilt 1999 · S/N 172S8178N974TASky Peak Aviation LLC · Los Angeles, CABuilt 2002 · S/N 172S9074N974THRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S12974N9750LLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1986 · S/N 17276608N9750QPurdy Adrian · Missouri City, TXBuilt 1975 · S/N 17265789N9751TAbles Marlan L · Carthage, ARBuilt 1960 · S/N 47551N97528Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276308N9752BUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1981 · S/N 172RG1012N9753TCowan Ronnie C · Glasgow, KYS/N 47553N97549Brandt Jeremy · Torrance, CAS/N 17276206
Back to AD 90-06-03 R1