OpenAirDocs.org
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.

N739ZNOur Jett LLC · Englewood, COBuilt 1978 · S/N 17270938N739ZPBlue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 17270939N739ZRJw Horton Aviation LLC · Rogers, ARS/N R18201021N739ZSPryor James A · Bottineau, NDS/N 17270942N739ZUMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270944N739ZWHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 17270946N739ZXN739zx Flying Association · Kent, WABuilt 1978 · S/N 17270947N739ZZR & R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270949N73ALHefel Lori A · Wichita, KSBuilt 1974 · S/N 177RG0559N73BJJewett Brandon M · Brighton, COBuilt 1975 · S/N 18502798N73BTDragging Tails LLC · Colbert, GABuilt 1965 · S/N 18051606N73CQHillesheim Steven T · Grass Valley, CABuilt 1958 · S/N 51251N73CYRti Fabrication Inc · Plains, MTS/N U20606815N73DAFlying Alaska LLC · Anchorage, AKS/N 185-0119N73EKOgrin Kirk W · Bigfork, MTBuilt 1978 · S/N 18503464N73FRWayman Luy LLC · Weston, FLBuilt 1979 · S/N 17273134N73GJSkydive Greene County Inc · Xenia, OHBuilt 1958 · S/N 51359N73GLG & N Enterprises LLC · Sparks, NVBuilt 1972 · S/N 18261599N73GMPrice Roger Paul · Punta Gorda, FLBuilt 1973 · S/N 18262679N73JJJj Ventures LLC · Billings, MTBuilt 1981 · S/N 18504241N73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidBuilt 1966 · S/N 15064948N73LHerald Gregory L · Coatesville, INBuilt 1963 · S/N 17250283N73LLT3 Aviation LLC · Oak Point, TXBuilt 1977 · S/N 21062163N73LT302 LLC · Anchorage, AKBuilt 1957 · S/N 32823N73MSJohnson Kevin N · Bethpage, NYBuilt 1977 · S/N 17268932N73PRegistered aircraftS/N 18262052N73PPArew Aviation LLC · San Tan Valley, AZS/N 17261627N73PWWarren John M · El Paso, TXBuilt 1971 · S/N 17259809N73RBTurbo Centurion LLC · North Salt Lake, UTS/N 21061758N73RJRichard Kent A · Sunset, LABuilt 1966 · S/N 15062833N73SC73sc Owners Group Inc · Torrance, CABuilt 1965 · S/N 18256623N73TFKlanchar Flying LLC · Benton, ARBuilt 1966 · S/N 17255638N73TPTop Aircraft Leasing LLC · Wilmington, DES/N 34665N73WPGemini 3 LLC · Cleves, OHS/N 17268849N740United States Department Of Interior · Boise, IDBuilt 1980 · S/N U20605724N7400AHarrop Brian C · Mesa, AZBuilt 1957 · S/N 29500N7400M7400m Air Inc · Auburn, ALBuilt 1958 · S/N 55700N7400XLandrush Construction LLC · Fairview, OKBuilt 1960 · S/N 17247900N7401ECosta Air Service LLC · Painted Post, NYBuilt 1959 · S/N 57101N74022Braatz Cannonf · Bend, ORBuilt 1958 · S/N 50324N7402QRichs Alaskan Flying Adventures LLC · Wasilla, AKBuilt 1973 · S/N U20602192N7402TKnox David B · Mc Arthur, OHBuilt 1959 · S/N 47002N7402XClemson Flying Club Inc · Seneca, SCBuilt 1960 · S/N 17247902N74036Pallen William T · Fargo, NDS/N 25506N7403TKoehn David Scott · Orange Beach, ALBuilt 1959 · S/N 47003N7403WJohnston Aircraft Leasing LLC · Highland, CABuilt 1956 · S/N 33109N7404MHrevans Cessna 175 LLC · Fairbanks, AKBuilt 1958 · S/N 55704N7404NFmy Aviationllc · Fort Myers, FLS/N 18263185N7404TRaptor Flight LLC · Fort Worth, TXBuilt 1959 · S/N 47004N7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLBuilt 1970 · S/N 17259105
Back to AD 87-20-03 R2