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.

N91170Paklook Air Inc · Bethel, AKBuilt 1969 · S/N 20700101N9117BPartridge John R · Manchester, NHS/N 36617N9117CRegistered aircraftBuilt 1978 · S/N R18200408N9117GAndrews Mimi Muldrow · Hilltop Lakes, TXBuilt 1971 · S/N 18260657N9117MPettigarrett LLC · Manchester, GABuilt 1976 · S/N 18264685N9117TMichaud Paul K · Forest Lake, MNBuilt 1959 · S/N 180-50617N9117UBahr Timmy A · Crandon, WIBuilt 1976 · S/N 15078068N91183Hatch Hyrum G · Gilbert, AZBuilt 1969 · S/N 20700106N9118BCulpeper Aviation LLC · Queen Creek, AZBuilt 1958 · S/N 36618N9118CWalter Tina R · Yorkville, CABuilt 1978 · S/N R18200409N9118THagen Bruce L · Reeder, NDBuilt 1959 · S/N 50618N9118U9118u LLC · Dover, IDBuilt 1976 · S/N 15078069N91190Renfro Michael W · Bethel, AKBuilt 1969 · S/N 20700109N91199Olmstead Daniel H · Kimberly, IDBuilt 1973 · S/N 18261967N9119ATorraca Peter · New York, NYBuilt 1958 · S/N 19349N9119GWinters Richard Linn · Chandler, AZBuilt 1971 · S/N 18260659N911ATW I F A (Washington International Flight Acad) LLC · Gaithersburg, MDS/N 17275869N911BWOlsen Garry O · Forest Lake, MNS/N 32863N911EWeiss Elliott · Fresno, TXS/N 20700747N911JTSchaefer Kent M · Anacortes, WABuilt 1957 · S/N 34629N911MCKing Daddy Aviation LLC · Madison, MSS/N 21057773N911MDAirplex Aircraft LLC · Springfield, MOBuilt 1957 · S/N 34174N911PBaldwin Andrew W · Lander, WYBuilt 1971 · S/N 172-60321N9120CFrison Joseph · Milton, WIBuilt 1954 · S/N 31219N9120GRoderi Air LLC · Berlin, MDBuilt 1971 · S/N 18260660N9120HKrieg Kristi · Tonasket, WAS/N 17265954N9120XStevens Matthew J · Onaway, MIBuilt 1961 · S/N 18253520N9121CBowser Justin · Colorado Springs, COBuilt 1954 · S/N 31220N9121HTwenty-One Flyers Inc · Norwalk, CTBuilt 1975 · S/N 17265955N91220Wall Christopher Kenneth · Rochester, NYBuilt 1968 · S/N 18052007N91221Marvin Ray · Tomahawk, WIS/N 19034/2N91223Taylor James R · Murfreesboro, TNBuilt 1969 · S/N 18052009N91224Peninsula Aero Technology Inc · Kenai, AKBuilt 1969 · S/N 18052010N91225Woodaman James G · Pasadena, CABuilt 1969 · S/N 18052011N9122CJohnson Joseph S · Eagle River, AKS/N 31221N9122TWerth Lance C · Johnson Lake, NEBuilt 1959 · S/N 50622N9122XBissell Lee G · Culver, ORBuilt 1961 · S/N 18253522N91230Cutting & Sektnan Inc · Mcminnville, ORBuilt 1969 · S/N 18052016N91231N91231 LLC · Columbia, MOBuilt 1973 · S/N 18261976N91236Skylane 73 LLC · Altadena, CABuilt 1973 · S/N 18261980N9123ASale Reported · Draper, UTSale reportedBuilt 1956 · S/N 18882N9123BStockton Clifford A · Anchorage, AKBuilt 1958 · S/N 36723N9123CRegistration Pending · San Bernardino, CARegistration pendingBuilt 1978 · S/N R18200411N9123HTwenty Three Juliet LLC · Tyler, TXBuilt 1976 · S/N 17265957N91245Delmonte Paul R · Mountain Green, UTBuilt 1974 · S/N 18052464N91249Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 18052023N9124AWest Kevin B · San Antonio, TXBuilt 1949 · S/N 18883N9124BRegenold John A · Saint Paul, MNS/N 30670N9124USmith Stanley P · Athens, ALBuilt 1976 · S/N 15078075N9125CHafen Aviation Group LLC · Pasadena, CABuilt 1954 · S/N 31224
Back to AD 87-20-03 R2