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.

N9638VCrazy Aces LLC · St George, UTBuilt 1974 · S/N 17264418N9638XPiper Earl Holdings LLC · Newark, DEBuilt 1986 · S/N 18268572N96393Graham Eric H · Johnson City, TXBuilt 1978 · S/N 18266705N9639XFerguson John · Montrose, COS/N 21057939N963AYStark Truss Co Inc · Canton, OHBuilt 1982 · S/N R18201908N963KMMiller Karl E Trustee · Chandler, AZBuilt 1974 · S/N 17264198N963MSMount San Antonio College · Walnut, CABuilt 1982 · S/N 15285655N963WAChase Kenneth C Jr · Rochester, MNS/N 15282882N963WMMorrison William S · Aliquippa, PABuilt 1980 · S/N R1723344N96403Skylens LLC · Hammond, LABuilt 1978 · S/N 18266708N9640BHanson Glen W · Anchorage, AKBuilt 1957 · S/N 32937N9640HCorriher Mark B · Mocksville, NCBuilt 1975 · S/N 17266287N9640QFour Zero Quebec Inc · Cheyenne, WYBuilt 1969 · S/N 18259642N9640TJohnson Joshua S · Lake Jackson, TXBuilt 1960 · S/N 57440N9640VN9640v LLC · Ann Arbor, MIS/N 17264420N96410Penny John C Jr · Sterling, COBuilt 1978 · S/N 18266709N96411Zz Top Rentals Inc · Missoula, MTBuilt 1978 · S/N 18266710N96416Wolstenholme Ralph E · Westfield, PABuilt 1978 · S/N 18266713N96418Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1978 · S/N 18266714N96419Thompson Steven · Rockwall, TXBuilt 1978 · S/N 18266715N9641BFlying Brown Dog LLC · Boulder, COBuilt 1957 · S/N 32938N9641HBarton Alva L · Hollister, CABuilt 1975 · S/N 17266288N9641QBhairavi Aviation LLC · Santa Clarita, CABuilt 1975 · S/N 17265725N9641VRink Douglas B · Woolwich, MEBuilt 1974 · S/N 17264421N9641ZWhitehead Michelle W · Centralia, WABuilt 1982 · S/N U20606592N9642TDavidow Clifford A · Portland, ORBuilt 1960 · S/N 57442N9643HMor Aviation N9643h LLC · Gaithersburg, MDBuilt 1975 · S/N 17266290N9643QLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265727N9643TDunn Meghan Elizabeth · Mckinney, TXBuilt 1960 · S/N 57443N9643VBrazos Valley Flight Services LLC · College Station, TXBuilt 1974 · S/N 17264423N9643ZAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1982 · S/N U20606594N9644GKatmai Air LLC · Anchorage, AKS/N U20601844N9644QSkyhawks Inc · Chippewa Falls, WIBuilt 1975 · S/N 17265728N9644TFloyd Andrew W · Mesa, AZBuilt 1960 · S/N 57444N96455Haeussler Arne · Chandler, AZBuilt 1978 · S/N 18266726N9645GConnolly Michael T · Ferndale, WABuilt 1974 · S/N 18263413N9645HSantiago Diana L · Juana Diaz, PRBuilt 1975 · S/N 17266292N9645VOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1974 · S/N 17264425N9645XCall The Ball Aviation LLC · Phoenix, AZS/N 21057945N96462Skylens LLC · Hammond, LABuilt 1978 · S/N 18266728N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942N9646XKomko Randy M · Mckenna, WABuilt 1962 · S/N 21057946N96474Skylane 4 LLC · Leesburg, FLBuilt 1978 · S/N 18266730N96475Gregg Flying Service Inc · Durango, COBuilt 1978 · S/N 18266731N96476After Global Holdings Corp · Wichita, KSBuilt 1978 · S/N 18266732N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943N9647QKaeni Law Group Inc · Santa Ana, CABuilt 1975 · S/N 17265731N96480Mfkc182 LLC · Lantana, TXBuilt 1978 · S/N 18266733N9648HSaunders Larry F · Sulphur Springs, ARBuilt 1975 · S/N 17266294N9648QGreen Bay Flying Club Inc · Krakow, WIBuilt 1975 · S/N 17265732
Back to AD 87-20-03 R2