OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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-08-08-R3')
    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-08-08-R3')
  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.

N926CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 2881040N926CKFly By Numbers LLC · Tallahassee, FLBuilt 1976 · S/N 28-7690327N926GZD & L Limited LLC · Medford, NJS/N 28-11249N926JMBlue Horizon Performance Inc · Kellogg, IABuilt 1979 · S/N 28R-7931255N926MKToothman John C · Fairmont, WVBuilt 1971 · S/N 28-7125138N926PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843289N9270BKenneson Jack A · Clarion, PABuilt 1996 · S/N 2843032N9270KSlc Service Leasing Company LLC · Tipton, IAFirst renewal noticeBuilt 1974 · S/N 28-7410027N9271WMcelwee Jerilyn · South Riding, VABuilt 1967 · S/N 28-10944N9272JEast Fork Flyers LLC · Lu Verne, IABuilt 1966 · S/N 28-3350N9272LValira Aviation II LLC · Oakland, CABuilt 1997 · S/N 2843077N9273BAll-In Aviation LLC · Fort Myers, FLBuilt 1996 · S/N 3246035N9273JWhite Raymond · Jasper, ARBuilt 1966 · S/N 28-3351N9273VLfc Solutions LLC · San Antonio, TXBuilt 1996 · S/N 3246036N9273WWhite J David · Louisville, KYBuilt 1967 · S/N 28-10946N9274JLund Christian W · New Ipswich, NHBuilt 1966 · S/N 28-3352N9274NOkuda Hideki · Rncho Pls Vrd, CABuilt 1996 · S/N 2844008N9274QTen Hi Flyers Inc · Denver, COBuilt 1996 · S/N 3246038N9274WSkubisz Jozef H · New Lenox, ILBuilt 1967 · S/N 28-10947N9274YFlight Club 502 Inc · Louisville, KYBuilt 1985 · S/N 28-8616020N9275JLow Country Flight Company LLC · Savannah, GAS/N 28-3353N9275XBarrakuda Ltd · Bend, ORBuilt 1996 · S/N 3246041N9276CRegistration Pending · Kissimmee, FLRegistration pending, pending cancellationBuilt 1978 · S/N 28-7816454N9276WWhitmire Matthew K · Artesia, NMBuilt 1968 · S/N 28-10950N92779Montana Land Properties LLC · Missoula, MTBuilt 1996 · S/N 3246047N9277BFishers Shop Inc · Xenia, OHBuilt 1996 · S/N 3246057N9277DBird Acquisition LLC · Phoenix, AZBuilt 1996 · S/N 2843047N9277FKrushefski Chet W · Cedar Park, TXBuilt 1996 · S/N 3246042N9277WMountjoy Trevor Douglass · Carbondale, COBuilt 1967 · S/N 28-10951N9278JMcbride Gary J · Niantic, CTBuilt 1966 · S/N 28-3357N9278WN9278w LLC · Corona, CABuilt 1967 · S/N 28-10952N9279JAndromeda Air LLC · Houston, TXBuilt 1997 · S/N 2843068N927DMGoat Rancho LLC · Euless, TXS/N 32-40225N927GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881075N927KRCandace A Larned Enterprises Inc · Long Beach, CABuilt 1973 · S/N 28R-7335156N927PADuncan Michael J · Danville, VABuilt 1977 · S/N 28-7716082N927TMGmr Leasing LLC · Lincoln, DES/N 28-21102N9280AApm Leasing LLC · Casper, WYBuilt 1985 · S/N 28-8616040N9280JLone Star Steel Structures LLC · Kaufman, TXS/N 28-3359N9280WWhiskey Charlie Aviation LLC · Reno, NVBuilt 1967 · S/N 28-10954N9281KBartels Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 28-7615192N9282CRegistration Pending · Augusta, KSRegistration pendingBuilt 1978 · S/N 28-7816455N9283JN9283j LLC · Boise, IDBuilt 1966 · S/N 28-3363N9283WJohnson Mark A · Norfolk, NEBuilt 1967 · S/N 28-10959N9284AGriffith Nathan · Boston, MABuilt 1985 · S/N 28-8616041N9284KMtm Aviation LLC · Lake Havasu City, AZBuilt 1976 · S/N 28-7615193N9284MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1985 · S/N 28-8616042N9284WGutierrez Daniel M · Kennett Square, PABuilt 1967 · S/N 28-10960N9284ZFlex Aircraft Leasing Co LLC · Detroit, MIBuilt 1997 · S/N 3246064N9285CSunset Flights LLC · Azusa, CABuilt 1978 · S/N 28-7890396
Back to AD 87-08-08 R3