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

N5649QTaylor Clayton T · Stockton, KSBuilt 1965 · S/N 3023N5649UAzille Keran · Massapequa, NYBuilt 1969 · S/N 28-26445N5649WSmith James L Jr · Des Arc, ARBuilt 1962 · S/N 28-808N5649YPotenza Austin · Phoenix, AZBuilt 1964 · S/N 27-2764N564DFPreiss Michael C · Southaven, MSS/N 269N564FLFlyguys Cessna 182 LLC · Royal Palm Beach, FLBuilt 1971 · S/N 28-7125406N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276N564KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843880N564MAIndia Charlie Alpha Aviation LLC · Missoula, MTBuilt 2005 · S/N 989-2005N564MCB Air Lc · Sikeston, MOBuilt 2000 · S/N 172S8512N564MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275714N564MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.300N564PCHargest Custom Cabinetry LLC · Clermont, NJBuilt 1998 · S/N 18280248N564PUPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 2842169N56500Bas Part Sales LLC · Greeley, COBuilt 1983 · S/N 7371CN56501Hair Heather D Trustee · Bonner, MTBuilt 1983 · S/N 8022CN56506Nassour Aviation Inc · Ellisville, MSBuilt 1973 · S/N 28-73-25641N5650JWaypoint LLC · Fairbanks, AKBuilt 1982 · S/N 7420CN5650PSlayton Paul · Roswell, NMBuilt 1982 · S/N 7398CN5650QOrtland Richard James · Franklin, MIS/N 681N5650RWaco Air LLC · Wolfeboro, NHBuilt 1982 · S/N 7373CN5650SOliver Jonathan · Maryville, TNBuilt 1966 · S/N MA-68N5650USkyways Group LLC · Greensboro, NCBuilt 1969 · S/N 28-26446N5650WRwk LLC · Anchorage, AKBuilt 1981 · S/N 7381CN56510Brocon Aviation LLC · West Des Moines, IABuilt 1973 · S/N 327340187N56515Norcross James H Jr · Homer, AKBuilt 1983 · S/N 7442CN56517Andrews Paul · Chugiak, AKBuilt 1983 · S/N 7450CN56518Cpf Money Processing Systems Inc · Spokane, WABuilt 1983 · S/N 7451CN5651BRoland David K · Lockhart, TXBuilt 1981 · S/N 8018CN5651DWhisper Lake Flair Corp · Soldotna, AKS/N 7438CN5651EMrzena Matthew D · Wasilla, AKBuilt 1982 · S/N 7407CN5651NEllett Robert T IV · Brookhaven, GABuilt 1982 · S/N 7433CN5651PSeremet Cristina L · Beaver Dam, WIBuilt 1959 · S/N 24-722N5651QKingdom Air LLC · Diamondhead, MSBuilt 1965 · S/N 3024N5651VBecker Florian Alexander · Fort Lauderdale, FLBuilt 1977 · S/N 32R-7780350N5652Leary Brian J · Fredricksburg, PABuilt 1972 · S/N 595N56520Mt Aircraft LLC · Port Orange, FLS/N 7454CN56521Hawkes Tyler · Rexburg, IDBuilt 1973 · S/N 28-73-25647N56524Registration Pending · West Palm Beach, FLRegistration pendingS/N 28-73-25650N56525Sadi Susan Salimi · Arlington, TXS/N 28-7325651N56526Registered aircraftBuilt 1983 · S/N 7458CN56527Kappel Kyle D · Crossville, TNBuilt 1973 · S/N 32-73-40189N56528Delzer James K · Sanger, TXBuilt 1984 · S/N 8023CN56529Jilek Peter A · River Falls, WIBuilt 1973 · S/N 34-7350346N5652CRegistered aircraftBuilt 1982 · S/N 7403CN5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912N5652HKerby Ryan S · Talkeetna, AKBuilt 1983 · S/N 7447CN5652LSkelton Thomas Nichols Jr · Jackson, MSBuilt 1977 · S/N MC-533N5652NMaule Airways Inc Trustee · Wilmington, DES/N 7456CN5652ULions Flyers Inc · Enterprise, ORBuilt 1983 · S/N 7455C
Back to AD 87-10-06 R1