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.

N9322DHitchcock Mark J · Scottsdale, AZBuilt 1958 · S/N 22-6335N9322JZollitsch Allan P · Lancaster, NYBuilt 1966 · S/N 28-3415N9322MQuebedeaux Rentals LLC · Deridder, LAS/N 1254N9322RNickname LLC · Scappoose, ORBuilt 1993 · S/N 2311N9322SBrungard Thomas L · Walnut Creek, CABuilt 1975 · S/N MC-342N9323ESchock Richard F II · Peoria, ILBuilt 1979 · S/N 17272226N9323FCouch Bill A · Palestine, TXBuilt 1964 · S/N 24-0025N9323JDaissaoui Anouar · Quincy, MABuilt 1966 · S/N 28-3416N9323MMichael Siewert · Columbus, OHS/N 1255N9323VRoll Douglas J · Bradenton, FLBuilt 1967 · S/N 28-11005N9324DRegistered aircraftBuilt 1958 · S/N 22-6337N9324JAdbdelsalam Moustafa · Buena Park, CABuilt 1966 · S/N 28-3417N9324KBellew Philip H · Gadsden, ALBuilt 1976 · S/N 28-7690243N9324MMcdonald Glenn · Uvalde, TXS/N 1256N9324SBas Part Sales LLC · Greeley, COBuilt 1975 · S/N MC-345N9324VPontoni Development Corp · Athens, MIS/N 690073N9324WB2w Corp · Winona, MNBuilt 1967 · S/N 28-11007N9325PCody William James · South Lyon, MIBuilt 1969 · S/N 24-4822N9325VJaa Holdings LLC · Springfield, ILS/N 690096N9325WStevens Daniel · Moss Point, MSBuilt 1968 · S/N 28-11008N9326DAll Seasons Aviation LLC · Laredo, TXBuilt 1982 · S/N 172RG1122N9326EWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 17272228N9326FLelys · Orland, CABuilt 1964 · S/N 24-0031N9326MWoods Brian S · Longview, TXBuilt 1966 · S/N 1258N9326VSprang Bob E · Smithville, OHBuilt 1969 · S/N 700002N9326YHand Timothy P · Osage Beach, MOBuilt 1960 · S/N TD-443N9327MChristensen Seth T · Hurricane, UTBuilt 1966 · S/N 1259N9327PKrb LLC · Rupert, IDBuilt 1969 · S/N 24-4825N9328JRegistered aircraftBuilt 1966 · S/N 28-3422N9328KSantoro Alexandre Jose · Mountain View, CABuilt 1976 · S/N 28R-7635232N9328MBeauchamp Michael · Las Vegas, NVBuilt 1966 · S/N 1260N9328WLahm Robert E · Parish, NYBuilt 1968 · S/N 28-11011N9329JBradford Earl · Fairview, MIFirst renewal noticeBuilt 1966 · S/N 28-3423N9329MSreffler Christine · Ballwin, MOBuilt 1966 · S/N 1261N9329NWang Huafei · Cupertino, CABuilt 1969 · S/N 28R-35029N9329PLenders Insurance Solutions Group LLC · Ozark, MOBuilt 1969 · S/N 24-4827N932AZN932az LLC · Miami, FLBuilt 1986 · S/N 17276586N932BJInnovets LLC · Monument, COBuilt 2007 · S/N 140N932BLS Lynes LLC · Wilmington, DEBuilt 2003 · S/N 1326N932DFHertz David R · Vermillion, SDBuilt 2018 · S/N 90342N932ECRegistration Pending · Panama City, FLRegistration pendingBuilt 2021 · S/N 2881512N932FSAviation Equipment Co LLC · Lincoln, NES/N 44-7995018N932GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881077N932JMTacos On Wheels LLC · El Paso, TXBuilt 1981 · S/N 18267894N932LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496420N932PRoss Brian D · Northfield, ILBuilt 2002 · S/N 3806N932PWWerner Thomas M · Petaluma, CABuilt 2019 · S/N 5094N932RTMeldrum Dallas K · Allen, TXBuilt 1999 · S/N 24086N932RVHeddy Danny L · Petaluma, CABuilt 2002 · S/N 90230N932SHBuell Travis W · Harper, TXBuilt 2005 · S/N 3899
Back to AD 87-10-06 R1