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.

N9390HBenke William A · Collinsville, OKBuilt 1975 · S/N 17266133N9391EGoodin David James · Yerington, NVBuilt 1979 · S/N 17272244N9392FBas Part Sales LLC · Greeley, COBuilt 1997 · S/N 17280205N9392HVc Flights LLC · Miami, FLBuilt 1975 · S/N 17266135N9393BCameron Joseph J · Tucson, AZBuilt 1981 · S/N 172RG0811N9394DRed Baron LLC · Middletown, DEBuilt 1984 · S/N 172RG1150N9394HJohnson Chester F III · West Ossipee, NHBuilt 1975 · S/N 17266136N9395BChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0812N9395HInosculation Air LLC · Summerville, SCBuilt 1975 · S/N 17266137N9396HHaley Robert Jay · Livermore, CABuilt 1975 · S/N 17266138N9397HFlight World Inc · San Juan, PRBuilt 1975 · S/N 17266139N9399E9 Echo LLC · Muskogee, OKBuilt 1979 · S/N 17272248N939AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13564N939SPAero Aircraft 12 LLC · Jacksonville, FLS/N 172S8876N93HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2000 · S/N 172S8643N93JSNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1972 · S/N 17260936N93KKMonmouth Area Flying Club · Lakewood, NJBuilt 1975 · S/N 17266160N93PSVanderflute Scott L · Lakewood, WAS/N 17251979N93TPBagley Corydon S · Holladay, UTBuilt 1965 · S/N 17252041N94000Champion Aircraft LLC · Valdosta, GAS/N 17258297N9400EVan Anda Aviation LLC · Apopka, FLBuilt 1979 · S/N 17272249N9400HRoach John C · Lawrenceburg, KYS/N 17266142N9400LMerino Cesar · Washington, DCBuilt 1986 · S/N 17276550N9401HConstantine Costas T · Newington, CTS/N 17266143N9404FBas Part Sales LLC · Greeley, COBuilt 1997 · S/N 17280229N9404HSowell Richard G · San Jose, CABuilt 1975 · S/N 17266145N9407HB2w Corporation · Winona, MNBuilt 1975 · S/N 17266147N9408LMccallum David DBA · Napa, CABuilt 1986 · S/N 17276551N9409LLaguna Verde Leasing Inc · Wilmington, DEBuilt 1986 · S/N 17276552N940AMOracle Aviation LLC · Omaha, NEBuilt 1981 · S/N 17275286N940FSYogini Modi · Homestead, FLBuilt 1979 · S/N 17272350N940RMSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2003 · S/N 172S9386N9411LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276553N9412BWilliams Francis · Chester, CTBuilt 1981 · S/N 172RG0815N9413HPayne Rachel L · Geneva, FLBuilt 1975 · S/N 17266150N9414HVandewalle Robert H · East Tawas, MIBuilt 1979 · S/N 17273141N9415BDulles Aviation Inc · Bristow, VABuilt 1981 · S/N 172RG0816N9415HDungan William T Jr · Marion, VABuilt 1975 · S/N 17266151N9417LJalomc LLC · Glassport, PABuilt 1986 · S/N 17276555N9417ZAmerican Aviation Inc · Brooksville, FLBuilt 1997 · S/N 17280265N941EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12976N941KBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12576N941RBTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2003 · S/N 172S9443N941SMSchmidt Aaron B · Auburn, ALS/N 172RG0278N941TH941th LLC · Bethany, OKBuilt 2024 · S/N 172S13141N941TWHodge Flight Services LLC · Pittsburg, CABuilt 1981 · S/N 17275446N9420EAero Quest LLC · Costa Mesa, CABuilt 1979 · S/N 17272256N9421DJeff Air Pilot Services LLC · Shelbyville, INBuilt 1984 · S/N 172RG1154N9421EStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N 17272257N9421ZL&W Leasing LLC · Smyrna, TNBuilt 1997 · S/N 17280267
Back to AD 90-06-03 R1