AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N9353VLangholz Denise M · Covington, WABuilt 1969 · S/N 700011N93541Gibbs Frederick L · Flagstaff, AZBuilt 1973 · S/N 73-32-126N9354JLamb David S · Yuba City, CABuilt 1966 · S/N 28-3453N9354MFresh Air Properties LLC · Hayesville, NCBuilt 1966 · S/N 1286N9354SLinda Ann Trust LLC · Dover, DES/N M-1654N9354VPinckney Robert L · Elgin, SCBuilt 1969 · S/N 700009N9354WBlue Horizon Aircraft LLC · Wilmington, DEBuilt 1968 · S/N 28-11042N93554Pittman Randy L · Morris, ILBuilt 1973 · S/N 74-31074N9355DHarris Chet A · Anchorage, AKS/N 18-6616N9355SBestway Pilot Car LLC DBA · Metropolis, ILBuilt 1975 · S/N M-1656N9355WEngland Noah C III · Lowell, NCBuilt 1968 · S/N 28-11043N9356DHammond Dwight L · Burns, ORS/N 18-6617N9356HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266113N9356JVali Air Service LLC · Livingston, MTBuilt 1966 · S/N 28-3455N9356MRegistered aircraftBuilt 1966 · S/N 1288N9356PMente Charles · Homestead, FLBuilt 1969 · S/N 24-4856N9356RQuality By Design Inc · Leesburg, FLBuilt 1978 · S/N R18200696N9356SHeman Christopher M · Lees Summit, MOBuilt 1975 · S/N M-1657N9356VWilson Willard L · Daphne, ALBuilt 1969 · S/N 700009N9356WOrtman Stephen B · Mill Creek, WABuilt 1968 · S/N 28-11045N93570Huffaker Kenneth Scott · Post, TXBuilt 1973 · S/N 73-32-116N9357DLeary Patrick W DBA · Lewistown, MTBuilt 1958 · S/N 18-6618N9357JKirchoff Jennifer L · Hamden, CTBuilt 1966 · S/N 28-3456N9357MSpencer Jared · Mandeville, LABuilt 1966 · S/N 1289N9357PNewman Joseph G · Grand Ledge, MIBuilt 1960 · S/N 24-2033N9357SWeiser Denis P · Osceola, IABuilt 1975 · S/N MC-354N9357VWise Christopher J · Plano, TXBuilt 1969 · S/N 700013N9358CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816466N9358ELechmanski Philip J · Shelter Island, NYBuilt 1979 · S/N 17272236N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546N9358PJeneson Tim · Ketchum, IDBuilt 1969 · S/N 24-4858N9358SAnderson Justin T · Franklin, OHBuilt 1975 · S/N M-1658N9358VEickman Jaret · Scottsdale, AZBuilt 1969 · S/N 700014N9358WPena Evan M · San Antonio, TXS/N 28-11047N9359DFejes James Michael Jr · Anchorage, AKBuilt 1958 · S/N 18-6620N9359HWarren Flying Club · Troy, MIBuilt 1975 · S/N 17266115N9359MStrohacker Louis W · Kerrville, TXS/N 1291N9359NMorristown Flying Service Inc · Talbott, TNBuilt 1969 · S/N 28R-35066N9359PCarter James D · Carlton, TXBuilt 1969 · S/N 24-4859N935AZN935az LLC · Miami, FLBuilt 2003 · S/N 40.320N935CWIn Flight Aircraft LLC · Howell, MIBuilt 2005 · S/N 4496213N935DELong Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990146N935ERChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 4496195N935GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881078N935KMBeachy Philip R · Bonners Ferry, IDBuilt 2019 · S/N JA1703105N935LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496423N935MBBrewer Marcus · Churubusco, INBuilt 2012 · S/N MB3N935PTTailspin Tommys Inc · Port Townsend, WABuilt 1974 · S/N 17263040N935SHZoom Zoom LLC · Scottsdale, AZBuilt 2023 · S/N 42035N93600Babcock Barry B · Monument, COS/N 73-31061
Back to AD 87-10-06 R1