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.

N93TPBagley Corydon S · Holladay, UTBuilt 1965 · S/N 17252041N94000Champion Aircraft LLC · Valdosta, GAS/N 17258297N94006Leading Edge Aviation Inc · Doylestown, PAFirst renewal noticeBuilt 1982 · S/N 15285582N9400EVan Anda Aviation LLC · Apopka, FLBuilt 1979 · S/N 17272249N9400GMurphy James T · Nashville, TNBuilt 1970 · S/N U20601600N9400HRoach John C · Lawrenceburg, KYS/N 17266142N9400LMerino Cesar · Washington, DCBuilt 1986 · S/N 17276550N9400XWilliams Dutch R · Mohave Valley, AZBuilt 1961 · S/N 21057700N94018Northern Air Transport Inc · Mora, MNBuilt 1974 · S/N 21060483N9401GNoble Cody Trustee · Ardmore, OKBuilt 1970 · S/N U20601601N9401HConstantine Costas T · Newington, CTS/N 17266143N9402CMontgomery Robert L · Port Angeles, WABuilt 1955 · S/N 31800N9402UMayrant Dawson Z · College Station, TXS/N 15078350N9402XSewell John · Sugar Grove, ILBuilt 1961 · S/N 21057702N94035Husbands David · Bosque, NMBuilt 1974 · S/N 21060487N9403CDobson Michael W · Konawa, OKBuilt 1955 · S/N 31801N9403UPaschal Engineering Inc · Houston, TXFirst renewal noticeBuilt 1976 · S/N 15078351N9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLBuilt 1981 · S/N 21064498N9404BRutledge Dianna G · Winder, GABuilt 1958 · S/N 55204N9404CBergh Gene H · Roberts, WIFirst renewal noticeBuilt 1955 · S/N 31802N9404HSowell Richard G · San Jose, CABuilt 1975 · S/N 17266145N9404UWhitcomb James F · West Ossipee, NHBuilt 1976 · S/N 15078352N94059Moriarty Gerald J · Anchorage, AKS/N 18503275N9405CRamsower Charles M · Parma, IDBuilt 1955 · S/N 31803N9405RJones Lance E · Duncan, OKS/N U20606853N9405UBishop Michael E · Clarkston, WAS/N 15078353N94061Guinn LLC · Bothell, WABuilt 1977 · S/N 18503276N9406UMontgomery Paul Richard · Fredericksburg, VABuilt 1976 · S/N 15078354N94077Milky Way LLC · Fresno, CABuilt 1974 · S/N 21060497N9407CTyrrell Richard E · Central, AKBuilt 1955 · S/N 31805N9407HB2w Corporation · Winona, MNBuilt 1975 · S/N 17266147N9407TBodin Logan T · Lake Charles, LAS/N 57207N9407XDriggers Kenneth Jerry · Rialto, CABuilt 1961 · S/N 21057707N9408HWanamaker Jeffrey Cass · Fall City, WABuilt 1981 · S/N 18267943N9408LMccallum David DBA · Napa, CABuilt 1986 · S/N 17276551N9408UTenhoff Lee L · Homer, AKBuilt 1976 · S/N 15078356N94097Registration Pending · St Simons Island, GARegistration pendingBuilt 1982 · S/N 15285595N9409LLaguna Verde Leasing Inc · Wilmington, DEBuilt 1986 · S/N 17276552N9409TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57209N9409UFree Wade · Sharon, OKBuilt 1976 · S/N 15078357N9409XEnergy Transfer Aviation LLC · Spring, TXBuilt 1985 · S/N 18268515N940AMOracle Aviation LLC · Omaha, NEBuilt 1981 · S/N 17275286N940FSYogini Modi · Homestead, FLBuilt 1979 · S/N 17272350N940RJLaguna Verde Leasing Inc · Wilmington, DEBuilt 1978 · S/N 15281680N940WSkyhawks Inc · Westminster, COBuilt 1965 · S/N 18256606N9410MWomack David H · Rayville, LAS/N 21059310N9410XHendrix Philip R · Corpus Christi, TXS/N 21057710N94112Cooper Robert Jb · Wichita, KSBuilt 1982 · S/N 15285600N94118Unique Educational Experiences · Long Beach, CABuilt 1982 · S/N 15285601N9411HFeaga Charles C · Abbot, MES/N 18503437
Back to AD 87-20-03 R2