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.

N9916ZWings Of Wisconsin LLC · New Richmond, WIS/N U20606744N99171Airlake Aero Inc · Lakeville, MNBuilt 1985 · S/N 17276414N9917BVisscher Ty · Santa Rosa, CABuilt 1957 · S/N 34317N9917ESopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1975 · S/N 18263977N9917NThunderbird LLC · Tacoma, WABuilt 1975 · S/N 18052572N9917QStill Flying LLC · Gibsland, LABuilt 1975 · S/N 17265861N9918EByrne Evan A · Mountain Lake Park, MDBuilt 1979 · S/N 17272289N9918NCalef Jere R Trustee · Mojave, CABuilt 1975 · S/N 18052573N9918QCerqueira Luiz Fernando · Orem, UTBuilt 1975 · S/N 17265862N9918VGray Paul W · Eads, TNBuilt 1966 · S/N 18051770N9919BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 172RG1080N9919EN9919e LLC · Rio Vista, TXBuilt 1975 · S/N 18263979N9919QBlomstrom Andrew R · Oregon, WIBuilt 1975 · S/N 17265863N991DMAircraft Registration Inc Trustee · KematenBuilt 1969 · S/N 33701177N991JWYochheim Brett · Zephyr Cove, NVS/N 18267061N991NADatkuliak Michael C · Beallsville, OHBuilt 1965 · S/N 17253709N99204Clayburn Billy G · Yelm, WAS/N 18267278N9920BSchultz Robert G · Baker, FLBuilt 1982 · S/N 172RG1081N9920VSkywarrior Flight Training Inc · Pensacola, FLBuilt 1974 · S/N 17264556N9920XPayne Ronald J II · Wasilla, AKBuilt 1961 · S/N 185-0120N9921AAllen Air Ltd · Wray, COBuilt 1950 · S/N 19281N9921EBigelow Jason A · Woodstock, ILBuilt 1975 · S/N 18263981N9921HDirodio Joseph · Ocala, FLBuilt 1981 · S/N 18268114N9921NHauxwell Bryan · Mccook, NEBuilt 1975 · S/N 18052576N9921XWinslow William G Jr · Show Low, AZBuilt 1961 · S/N 1850121N9922AWilliamson Cordy M · Darlington, SCS/N 19282N9922BStix David Jr · Fernley, NVBuilt 1957 · S/N 34322N9922GAguilar William A · Puyallup, WABuilt 1973 · S/N A1500468N9922NRobert N Shadduck LLC · Boulder, MTS/N 18052577N9922XDooleys LLC · Glendale, AZBuilt 1961 · S/N 185-0122N9922YInfinite Wings LLC · Henderson, NVBuilt 1982 · S/N 21064640N9923BFurtak Stephen A · San Diego, CAS/N 34323N9923EBulloch Troy P · Cedar City, UTBuilt 1985 · S/N 18268471N9923NMontana Capital Holdings LLC · Missoula, MTS/N 18052578N9923TPrevo Jerry L · Anchorage, AKS/N 18253023N9923VFive Pines Aviation LLC · Casper, WYBuilt 1966 · S/N 18051775N9923YPostupack Peter Jr · New Cumberland, PABuilt 1982 · S/N 21064641N9923ZChena River Aviation Inc · Fairbanks, AKBuilt 1983 · S/N U20606747N99243Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276418N9924AAbner Cody J · Cleburne, TXBuilt 1966 · S/N 18256978N9924BNatre Air II LLC · Tipton, INBuilt 1982 · S/N 172RG1082N9924NMulcaire Jess · Camp Verde, AZBuilt 1975 · S/N 18052579N9924QMy Way Aviation LLC · Weston, FLBuilt 1975 · S/N 17265868N9924RInzer James Clarence IV · Baton Rouge, LABuilt 1986 · S/N U20606983N9924TBlue Skies Aviation LLC · Wall, SDBuilt 1960 · S/N 18253024N9924VEdwards Kevin M · Grass Valley, CAS/N 17264558N99253Mitiguy Aviation LLC · Stow, MABuilt 1985 · S/N 17276421N9925BMartell Summer · Port Townsend, WABuilt 1957 · S/N 34325N9925EMeredith Dean J · Boynton Beach, FLBuilt 1975 · S/N 18263985N9925GPetecraft Aviation Services Inc · Plains, GABuilt 1971 · S/N 18800725
Back to AD 87-20-03 R2