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.

N652RVKracmer Thomas J · Fort Myers, FLBuilt 2012 · S/N 71856N652SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8058N652SRBracy Rodney E · Middleville, MIBuilt 1968 · S/N 17701014N65306Bullet Power Brokers Inc · Stuart, FLBuilt 2004 · S/N 18281420N65309Satoyama Molokai LLC · Kaunakaka Molokia, HIBuilt 2004 · S/N T20608482N6530HWagons West LLC · Myrtle Beach, SCBuilt 1975 · S/N 17265477N6530JSalmon Woody W · Chalkyitsik, AKBuilt 1968 · S/N 28-4969N6530RByers Travis M · Villa Rica, GABuilt 1979 · S/N 172RG0199N6530UHeidelberg Haley · Huntington, TXBuilt 1962 · S/N 2313N6530ZElk Mountain Soaring LLC · Bountiful, UTBuilt 1962 · S/N 25-2063N6531CDorr Juergen W · Mundelein, ILBuilt 1978 · S/N 28-7890380N6531JLoehrer Daniel J · Milbank, SDBuilt 1968 · S/N 28-4970N6531RBruno Gennaro S · Lewes, DEBuilt 1979 · S/N 172RG0200N6531YSmith Henry C III · Essexville, MIBuilt 1967 · S/N 27-3824N65324Bickerstaff Mike · Port Orange, FLBuilt 2004 · S/N 18281421N65328Lingyun LLC · Winter Garden, FLBuilt 2004 · S/N 18281462N6532CQuartarolo Pete · Santa Rosa, CABuilt 1978 · S/N 28-7890381N6532FCouch Walter Jack · Patterson, LAS/N 17273234N6532JGarner Aviation LLC · Tampa, FLS/N 17273885N6532PCarlsson Carl J · Mason City, IABuilt 1960 · S/N 24-1654N65339Shaw Andrew G · Huntingdon, PABuilt 1999 · S/N 565N6533JPaulson James L · Lawrenceville, NJBuilt 1968 · S/N 28-4973N6533LNorthcutt Cecil W III · Ponder, TXBuilt 1974 · S/N AA5-0633N6533PRegistered aircraftBuilt 1957 · S/N 24-1655N6533W21 Luna LLC · Phoenix, AZBuilt 1965 · S/N 28-20612N65348Anselmetti Federico · South Miami, FLBuilt 2004 · S/N T18208311N6534BMurphy Timothy · Lake City, FLS/N 1203N6534PNorwood Comanche Flyers LLC · Quincy, MABuilt 1959 · S/N 24-1656N6534UHuertas Andrew · Van Nuys, CAS/N 2317N65358Peanut Productions LLC · Sheridan, WYBuilt 2004 · S/N 18281424N6535GBbjs Investments LLC · Burlington, WIBuilt 1979 · S/N 17273606N6535HAerial Sign North Inc · Lakewood, NJBuilt 1946 · S/N 19722N6535PPetter Kristopher · Orient, IABuilt 1959 · S/N 24-1657N6535TDobson Richard W · Phenix City, ALBuilt 1968 · S/N MB-360N65367Wheels Up Re LLC · Odenville, ALBuilt 2004 · S/N 18281435N6536JCooper David M · Sedona, AZS/N 28-4977N6536VTran Dai A · Rancho Cucamonga, CABuilt 1980 · S/N 172RG0760N6536WDenny David F · Bath, NCS/N 28-20615N6537AYellow Jacket Aero LLC · Plymouth, MNBuilt 1978 · S/N 27-7954002N6537DCunningham Edward A · Washington, DCBuilt 1979 · S/N 17272853N6537FWheels Up Aviation LLC · Pittsburgh, PABuilt 1979 · S/N 17273236N6537HRivers Robert A · Oxford, NCBuilt 1975 · S/N 17265480N6537JTimer Anna Mae · Wildwood Crest, NJBuilt 1968 · S/N 28-4978N6538FMbk Leasing And Consulting LLC · Lakeland, FLBuilt 1979 · S/N 17273237N6538JBerra Robert J · Burtonsville, MDS/N 28-4980N6538PStorck Andrew D · Dayton, OHBuilt 1959 · S/N 24-1660N6538RFunnell John R · Cedar Park, TXBuilt 1974 · S/N MB-712N6538VSommer Timothy T · Combined Locks, WIBuilt 1980 · S/N 172RG0762N6538WVenture Flying LLC · Mobile, ALBuilt 2004 · S/N 18281440N6539HAbove The Haze LLC · San Lorenzo, CAS/N 17265481
Back to AD 87-10-06 R1