AD 87-20-03 R2

Registered aircraft · 54,015

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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.

N9823XTop Hand Inc · Laurel, MTBuilt 1961 · S/N 185-0023N9824HClimb LLC · Kalispell, MTS/N 18268052N9824JBarksdale James Alan · Florence, ALBuilt 1980 · S/N 17273925N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624N9824TNeufeld Dwayne A · Coeur D Alene, IDBuilt 1960 · S/N 47624N9824VSafety In Motion Flight Center · Puyallup, WABuilt 1974 · S/N 17264516N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725N9825TLong Duane C · Baskin, LABuilt 1960 · S/N 47625N98264Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276271N9826ADanek Brian C · Morris, ILBuilt 1950 · S/N 7505N98271Mastin Aviation Inc · Pasadena, MDBuilt 1984 · S/N 17276272N9827CKae Aviation LLC · Conover, WIBuilt 1978 · S/N R18200449N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727N9828AMitchell Thomas H · Kennewick, WABuilt 1950 · S/N 7507N9828ETa Wellner Group LLC · Lake Oswego, ORS/N 18263923N9828JIcarus Copters LLC · Lancaster, CABuilt 1975 · S/N A1500637N9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1986 · S/N 17276625N9828TArts Donald W · Lincoln, CABuilt 1960 · S/N 47628N9828XPathfinder Aero Services LLC · Sheridan, WYS/N 1850028N9829ARoy Rodney E DBA · Grand Marais, MNS/N 7508N9829HWright Steven · Shelbyville, TNBuilt 1981 · S/N 18268054N9829JInflight Corp · Chaffee, MOBuilt 1980 · S/N 17273928N9829MRyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700741N9829TGeske Kenneth A · Thief River Falls, MNBuilt 1960 · S/N 47629N982SFBauermeister Matthew · Lake Tapps, WABuilt 1970 · S/N P20600644N982SKRowe Andrew L Jr · Hope, MEBuilt 1974 · S/N 17264042N98306United States Air Force Owner · Usaf Academy, COBuilt 1985 · S/N 17276276N9830GGonzalez Nicolas · Naples, FLBuilt 1971 · S/N 17259730N9830JJohnsen Christian · Big Bear Lake, CAS/N A1500639N9830TPoe Joshua J · Peculiar, MOBuilt 1960 · S/N 47630N9830VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264518N9830XWard Todd · Corona, CAS/N 185-0030N9831GStarr David · Mount Prospect, ILBuilt 1979 · S/N 17273637N9831JHaddix Stanley D · Hagerhill, KYBuilt 1975 · S/N A1500640N98323Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276277N98326Lum Barnett K · Temple City, CABuilt 1984 · S/N 17276278N9832JWolfe William Keith · Greenbrier, ARBuilt 1975 · S/N A1500641N9832XAlbert Bryan W · Palmer, AKBuilt 1961 · S/N 1850032N9833AKreit Kenneth Samuel · Catlett, VABuilt 1950 · S/N 7512N9833HMccool Air Service Inc · Mc Cool Junction, NEBuilt 1981 · S/N 18268055N9833VMartin Kendall L · Wills Point, TXBuilt 1974 · S/N 17264521N9834CN8184h LLC · Thiensville, WIBuilt 1978 · S/N R18200454N9834GNielson Douglas W · East Troy, WIBuilt 1971 · S/N 17259734N9834LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276628N9834THulbert Douglas S · Santa Maria, CABuilt 1960 · S/N 47634N9834XPemberton Ryan A · Valleyford, WABuilt 1961 · S/N 185-0034N98352Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276281N98354Jin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276282N9835AMcclain Aviation LLC · Roanoke, TXBuilt 1950 · S/N 7528
Back to AD 87-20-03 R2