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.

N9236HOptic Air LLC · Sioux Center, IABuilt 1975 · S/N 17266034N923AZN923az LLC · Miami, FLBuilt 2025 · S/N 172S13280N923CTBragdon Emil · Fort Worth, TXS/N 172S8663N923EDJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10624N923EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13038N923EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12979N923GWCape Island Aviation LLC · Millville, NJBuilt 2002 · S/N 172S9023N9240HPropability One LLC · Daytona Beach, FLBuilt 1975 · S/N 17266038N92424Christiansen Cortland · Bakersfield, CAS/N 17261573N9242HRoland Aviation LLC · Gualala, CABuilt 1975 · S/N 17266040N9243HSeward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 17266041N92445Pureflight Aviation Training LLC · Newberg, ORBuilt 1973 · S/N 17261575N92447American Patrols Inc · Midland, TXBuilt 1973 · S/N 17261576N92448Eckholt John · Forest Grove, ORBuilt 1973 · S/N 17261577N9244HCoachron Investments LLC · Grosse Ile, MIBuilt 1975 · S/N 17266042N9246NWestways Aviation LLC · El Cajon, CAS/N 17269246N92471Shoemaker Floyd · Oneida, TNS/N 17261579N9249HGencur Paul A · Hudson, OHBuilt 1975 · S/N 17266044N924AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13561N924AZN924az LLC · Miami, FLBuilt 2025 · S/N 172S13282N924CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8912N924LPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2002 · S/N 172S9204N924MCJ Airco LLC · Nashville, TNBuilt 1985 · S/N 17276509N9250VFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11182N9252HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17266047N92548Pulliam Richard W · Henryetta, OKBuilt 1973 · S/N 17261584N9254CFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11183N9254HShipley Donald E · Alpine, TXBuilt 1975 · S/N 17266049N9254YFlorida Memorial University Inc · Miami Gardens, FLBuilt 2012 · S/N 172S11192N92570Becker Steven H · Prescott, AZBuilt 1973 · S/N 17261586N92595Bearfight Aviation LLC · Dover, DEBuilt 1973 · S/N 17261591N9259HBooke Phillip Austin · Anniston, ALS/N 17266053N925CBDhani Errol · Locust Grove, GABuilt 1973 · S/N 17262826N925CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8913N925EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13340N925MHAir America Imagery LLC · Daytona Beach, FLBuilt 1999 · S/N 17280731N925MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275341N925YZFranchetti Kevin · Manchester, MEBuilt 2005 · S/N 172S9869N92617Stahl Raifen · Anchorage, AKBuilt 1973 · S/N 17261594N9261HSchrom Frederick A · Carlisle, PABuilt 1975 · S/N 17266054N9262HAero Maintenance Inc · Vancouver, WAS/N 17266055N9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1975 · S/N 17266056N9265HCleveland Douglas P · Live Oak, FLBuilt 1975 · S/N 17266057N9269HLargen Gregory K · Benton, KSBuilt 1975 · S/N 17266059N926AMGlisson Susan M · Evansville, INBuilt 2001 · S/N 172S8772N926CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8914N926CRAero Tech Services Inc · Lititz, PABuilt 2020 · S/N 172S12537N926JAMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10926N926MNPtw Consulting LLC · Atlanta, GABuilt 1971 · S/N 17260325N926NLRemington Robert J · Sheboygan Falls, WIS/N 172S8812
Back to AD 90-06-03 R1