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.

N84082Weinheimer Paul T · Amarillo, TXBuilt 1969 · S/N 17258326N84086Smoky Mountain Flyers · Murphy, NCBuilt 1969 · S/N 17258327N8408UMastey Patrick R · Saint Cloud, MNS/N 17252308N84092Brown Stephen J · Chandler, AZBuilt 1969 · S/N 17258328N84093Hruska Coyle J · Lime Springs, IABuilt 1969 · S/N 17258329N84097Argoudelis Michael · Kalamazoo, MIS/N 17258331N8409LRegistered aircraftBuilt 1968 · S/N 17256609N8409XAlbers Stanley F · Hazlet, NJBuilt 1961 · S/N 17248909N840KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12804N840MCLegends Air Center LLC · Bentonville, ARBuilt 2007 · S/N 172S10440N840PAChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10640N840SUOhio State University · Columbus, OHBuilt 2020 · S/N 172S12433N84104Morris Daniel B · Ankeny, IABuilt 1969 · S/N 17258334N84105Jost Jared D · Hillsboro, KSS/N 17258335N84108Bramblett John S · Russellville, ARBuilt 1969 · S/N 17258337N8410ETito Hector · Fayetteville, GABuilt 1979 · S/N 17272196N8410LVictory Lane Aviation LLC · Concord, NCBuilt 1968 · S/N 17256610N8410UMcbride Robert D · Buffalo, WYBuilt 1964 · S/N 17252310N8410XFondy Investments LLC · Anchorage, AKS/N 17248910N84114Miami Seaplane Tours Inc · Miami, FLBuilt 1969 · S/N 17258339N84117Mendez Arturo · Addison, ILBuilt 1969 · S/N 17258340N8411UNeu Aviation LLC · Benton, LABuilt 1964 · S/N 17252311N8411XOrr Kent C · Kearney, NEBuilt 1961 · S/N 17248911N84122Millican Marc J · Anchorage, AKBuilt 1969 · S/N 17258342N84125Koenig Aircraft Restoration Inc · Loranger, LABuilt 1969 · S/N 17258343N84129Petschow Kenneth W · Upland, CABuilt 1969 · S/N 17258344N8412LAddison Flying LLC · Addison, NYBuilt 1968 · S/N 17256612N8412U8 For 9 LLC · Scotia, NYBuilt 1965 · S/N 17252312N8412XSuttle Joe Albert · Moody, ALBuilt 1961 · S/N 17248912N84130Gutierrez Sergio E · Pharr, TXBuilt 1969 · S/N 17258345N84133Registration Pending · Bowman, NDRegistration pendingS/N 17258347N8413LRussell Adam G · Easton, MES/N 17256613N8413XPilot Pros Inc · Miami, FLBuilt 1961 · S/N 17248913N84140Kaiser Joe E · Anchorage, AKBuilt 1969 · S/N 17258351N84141Registration Pending · Mansfield, OHRegistration pendingBuilt 1969 · S/N 17258352N84143Jones Donald T · Barrigada, GUS/N 17258353N84146Stone Air LLC · Carrollton, GABuilt 1969 · S/N 17258354N84147Cox James O II · Shady Shores, TXBuilt 1969 · S/N 17258355N8414LMorris Christopher J · Manor, TXBuilt 1968 · S/N 17256614N8414UHanan Rose R · Arcata, CABuilt 1964 · S/N 17252314N8414XRps-Lrs Investments Inc · Wilmington, DEBuilt 1961 · S/N 17248914N8415Marcy Arthur W · Appleton, WIBuilt 1964 · S/N 17252315N84151Sanders George W · Cloverdale, INBuilt 1969 · S/N 17258358N84153Spirit Air Inc · Salmon, IDBuilt 1969 · S/N 17258360N84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258362N84169Roach Gene T · Frankfort, KYS/N 17258363N8416UKing J Boyd · Snover, MIBuilt 1964 · S/N 17252316N8416XBas Part Sales LLC · Greeley, COS/N 17248916N84170Follmer Todd F · Dunwoody, GABuilt 1969 · S/N 17258364N8417UPeninsula Aero Technology Inc · Kenai, AKBuilt 1964 · S/N 17252317
Back to AD 90-06-03 R1