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.

N63095Boyle Daniel K · Llano, TXBuilt 1975 · S/N 15077101N6309BDz Aviation LLC · Nephi, UTBuilt 1957 · S/N 34209N6309GJohnson Robert W · Lebanon, TNS/N 15071809N6309SRegistered aircraftBuilt 1967 · S/N 15067109N6309VHamilton Paul L · Arlington, VABuilt 1980 · S/N 172RG0617N630AMBhh Leasing #3 LLC · Pensacola, FLBuilt 1968 · S/N 337-M0347N630ATAir Tiger LLC · Eunice, LAS/N 18267075N630TCN630tc LLC · Nashville, TNBuilt 1976 · S/N 17267047N63101Gill Michael J · Marshfield, MABuilt 1981 · S/N 17275391N6310BWilliams Clayton S · Mason, NHBuilt 1957 · S/N 34210N6310EMinor Mark · Central Point, ORBuilt 1959 · S/N 46410N6310FKierstead Andrew R · Alton Bay, NHS/N 337-0310N6310GAerostar Management Services LLC · Kissimmee, FLS/N 15071810N63113High Road Time LLC · West Palm Beach, FLS/N 17275392N63114Rgw Aviation LLC · Wilmington, DEBuilt 1975 · S/N 15077113N6311FGlasow Eric J · Simpsonville, SCBuilt 1966 · S/N 337-0311N63120Dean James J · Tampa, FLBuilt 1975 · S/N 15077116N63121Aba Contractors Inc · Arcadia, OKBuilt 1975 · S/N 15077117N63122Registered aircraftBuilt 1975 · S/N 15077118N63125Registration Pending · Burnsville, MNRegistration pendingBuilt 1975 · S/N 15077121N63126Aero Marine Inc · Westland, MIBuilt 1975 · S/N 15077122N6312AJosephine Air LLC · Castle Rock, WAS/N 33112N6312BUsda Forest Service Fepp · Helena, MTBuilt 1957 · S/N 34212N6312FCade Steve DBA · Lopez Island, WABuilt 1966 · S/N 337-0312N6312GAshe Robert W · Bethel, CTBuilt 1970 · S/N 15071812N63130Box Talon · Cotulla, TXS/N 18052831N63132Ha Peter · Eastvale, CABuilt 1975 · S/N 15077124N63138Sport Flyer Service LLC · Katy, TXBuilt 1975 · S/N 15077130N6313BLashbrooke Dana F · Durango, COS/N 34213N6313EGottshall Curt E · Monroe, WABuilt 1959 · S/N 46413N6313FTeens In Flight Inc · Palm Coast, FLBuilt 1979 · S/N 17273188N63145Morin James R · West Ossipee, NHS/N 18052833N63149Aviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 15077138N6314AGarletts Frank · Jackson, MSBuilt 1956 · S/N 33114N6314BGregg Delvin K · Durango, COBuilt 1957 · S/N 34214N6314CC4p LLC · Jackson, TNFirst renewal noticeBuilt 1980 · S/N 21063861N6314DSaghafi Jamsheed Trustee · Parma, OHBuilt 1978 · S/N 21062938N6314EWeber Tom L · Douglas, WYBuilt 1959 · S/N 46414N6314GKing William E · Simpsonville, SCBuilt 1970 · S/N 15071814N6314LCzed Investments · Westlake, LABuilt 1980 · S/N 15284385N63150Parrish Jonathan · Boulder City, NVBuilt 1962 · S/N 15059756N63154Burleson James G · Grand Prairie, TXBuilt 1975 · S/N 15077142N63155Morten David J · Larimore, NDS/N 15077143N63157Tadres Abanob Y · Antioch, TNBuilt 1975 · S/N 15077145N6315APerkins Larry L · Wildomar, CABuilt 1956 · S/N 33115N6315BEbright Sean E · Hasty, COS/N 34215N6315FSavidge Lenice M · Rogers, ARS/N 337-0315N6315SDelta Delta Aviation Group Inc · New Castle, DEBuilt 1967 · S/N 15067115N63165Eagle Eye Aviation LLC · Mccomb, MSBuilt 1975 · S/N 15077150N63166Chucks Aircraft LLC · Hartland, MES/N 18052834
Back to AD 87-20-03 R2