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.

N95CPGates Thomas S · Moyock, NCBuilt 1976 · S/N 17265896N95DMValley Gabriel P · Holden, MES/N 18504319N95EAFray Jonathan C · Wasilla, AKS/N 18052052N95EMHoeft Gregory D · Glennallen, AKBuilt 1963 · S/N 18051306N95FCDerscos LLC · Colorado Springs, COBuilt 1975 · S/N 18263694N95GCGrant James T · Huntsville, ALBuilt 1960 · S/N 47386N95GRSim International Inc · Fort Mill, SCBuilt 1978 · S/N 18266666N95GSStephen George A · Anna Maria, FLBuilt 1979 · S/N 18267146N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015N95JRKaiser Dennis · Portland, MEBuilt 1980 · S/N 18504074N95MBNobbe Leon W · Greensburg, INBuilt 1977 · S/N 18265872N95MRH&M Air LLC · Georgetown, TXBuilt 1973 · S/N 18261797N95PFEhorn William M · Cottonwood, CAS/N 18265281N95PYJayviation Inc · Lake City, FLBuilt 1964 · S/N 21058514N95REMcquown Todd J · Montgomery, TXBuilt 1955 · S/N 31835N95TFSage Mgmt LLC · Carefree, AZBuilt 1981 · S/N U20606137N95UObrien Laurence J · Northridge, CABuilt 1951 · S/N 7714N96019Bunde Conley R · Anchorage, AKBuilt 1960 · S/N 50901N9601QSteel Aviation Inc · Walnut Cove, NCBuilt 1975 · S/N 17265686N9601XCervantes Jose M · San Diego, CAS/N 21057901N96024Strite Jaylon · Cochise, AZS/N R172-0148N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912N9602HC & J Flight Co LLC · Sardis, MSBuilt 1981 · S/N 18267969N9602XMorehouse Darrell L · Glasgow, MTBuilt 1962 · S/N 21057902N9603QConnecticut Flyers Inc · Madison, CTBuilt 1975 · S/N 17265688N9603XTerry Nickolas B · Maize, KSBuilt 1962 · S/N 21057903N96047Ohio Car Wash Supply LLC · Lancaster, OHS/N 18264485N9604GRoberts Development Company Inc · Tucson, AZBuilt 1972 · S/N U20601804N9604TKay Bennie L · Brigham City, UTBuilt 1961 · S/N 57404N96051Franklin Evelyn Ruth Trustee · Laveen, AZS/N 18264408N9605QBragan Ryan J · Dunedin, FLBuilt 1975 · S/N 17265690N9605XTony Flies Inc · Sparta, NCBuilt 1962 · S/N 21057905N96061Wold Wayne T · Wasilla, AKFirst renewal noticeS/N R1720089N9606BAnderson David R · Sycamore, ILBuilt 1957 · S/N 32903N9606GJack Leasing Services Inc · Duchesne, UTBuilt 1974 · S/N 18801556TN9606XRowland Douglas · Wichita, KSS/N 21057906N9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeBuilt 1975 · S/N 17266260N9607XBaldridge Steven J · Edmonds, WAS/N 21057907N9607YIsn Aviation LLC · Loup City, NEBuilt 1981 · S/N 21064559N9608GCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601808N9608HCag Aircraft Holdings LLC · Crystal River, FLBuilt 1975 · S/N 17266261N9608QLahmers Melvin E · Newcomerstown, OHBuilt 1976 · S/N 17265693N9608XEsdaile Philip J · Woodland, CABuilt 1962 · S/N 21057908N96092Florida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1985 · S/N 15286006N96096Jwa Flight School LLC · Bolingbrook, ILBuilt 1985 · S/N 15286007N9609QWestrup Gregory W · Greensburg, INBuilt 1975 · S/N 17265694N960FSSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263386N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020N96105Demon Air LLC · Palm City, FLS/N 17276023N9610GChoice Aviation LLC · Hamilton, MTBuilt 1972 · S/N U20601810
Back to AD 87-20-03 R2