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.

N3995LLee Valerie A · Newville, ALBuilt 1966 · S/N 17254164N3996QLuther Turner S · Perry, FLBuilt 1971 · S/N 17260096N3996SNavarro Herbert R · Flagstaff, AZBuilt 1964 · S/N 17251196N3997QMurray Edward K · Fallbrook, CABuilt 1971 · S/N 17260097N3997SJazc LLC · Doniphan, NEBuilt 1964 · S/N 17251197N3998LKansas Copters & Wings Inc · Augusta, KSBuilt 1966 · S/N 17254167N3999LMorris Jeffrey A · Lake Delton, WIS/N 17254168N399AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2015 · S/N 172S11553N399ESBray Aviation LLC · Calera, OKBuilt 1997 · S/N 17280155N39JJStag Aviation LLC · Tomball, TXBuilt 1966 · S/N 17254265N39PDBechard Barry C · Mount Joy, PABuilt 2000 · S/N 172S8424N3BYJamora Daniel L · Victorville, CABuilt 1969 · S/N 17257965N3CLWehner Kaitlyn M · Malone, WIBuilt 1968 · S/N 17257531N3HLLamarr Ryan A · Greenview, CABuilt 1957 · S/N 29935N3HQChesapeake Searey LLC · Wilmington, DES/N 17269154N3JARegistered aircraftBuilt 1975 · S/N 17266528N3KVAirmax Charters LLC · Lake Worth, FLBuilt 1981 · S/N 17274768N3PVAtkinson Russell M · Concord, CAS/N 17251739N3RWGordon George M Jr · Weston, MABuilt 1978 · S/N 17271069N3RXMorelli Michael V · Kenilworth, ILBuilt 1974 · S/N 17264044N3SFPowers Gilford L · Glenville, NYBuilt 1970 · S/N 17259442N3TNChamplain Flyers LLC · Westford, VTBuilt 1974 · S/N 17263547N4000FDe Lisio Frederick C · Andover, MABuilt 1958 · S/N 36900N4000XJp Skyward LLC · Ontario, CABuilt 1998 · S/N 172S8010N4003FMartin Rogers K · Rome, GABuilt 1958 · S/N 36903N4004FCreelman Richard A · San Marcos, TXBuilt 1958 · S/N 36904N4005FRound Engine Aero · Nashville, MIS/N 36905N4006FBig Sky Fkyers LLC · Billings, MTS/N 36906N400GEFreeway Airport Inc · Mitchellville, MDBuilt 1981 · S/N 17275445N400LAPacific Fleet Aviation LLC · Rochester, NYS/N 17274388N400SKCappello Dave A · Cottonwood, CABuilt 1967 · S/N 17256077N4010FLarsen Harry A · The Dalles, ORBuilt 1958 · S/N 36910N4011FMiller Kerry N · Owensville, MOBuilt 1958 · S/N 36911N4014FMaxification LLC · Lavonia, GABuilt 1958 · S/N 36914N401AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2020 · S/N 172S12509N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 172S12535N401GTCastillo Giovanny G · Brodheadsville, PABuilt 1966 · S/N 17255188N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401LPMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9401N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N4020FBarnard David P · Delmar, NYBuilt 1958 · S/N 36920N4021Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1979 · S/N 17272149N4022WAero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10131N4025FBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1958 · S/N 36925N4029FMcelhaney Jung R · Phelan, CABuilt 1958 · S/N 36929N402CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13235N402DJFlying Mermaid LLC · Aiea, HIS/N 172S9290N402ERLeighnor Aircraft LLC · Prescott, AZBuilt 1997 · S/N 17280242N402PEDiegos Pet Rescue LLC · Orlando, FLBuilt 1998 · S/N 17280594
Back to AD 90-06-03 R1