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.

N6965DFondy Victor L · Whitewood, SDBuilt 1957 · S/N 18-5543N6965JDanik LLC · Harper Woods, MIBuilt 1976 · S/N 28-7690442N6965PBoucher Bobbi · Fredericksburg, VABuilt 1960 · S/N 24-2105N6965WSitaras Evangelos · Ladonia, TXBuilt 1965 · S/N 28-21162N6966CSchlichter Timothy J · Huntsville, ALBuilt 1978 · S/N 28-7816443N6966JTwo Mile Final LLC · Spring, TXBuilt 1976 · S/N 28-7690443N6966RHill Aviation LLC · Starkville, MSBuilt 1974 · S/N M-1616N6966UUnderhill Robert A · Redding, CABuilt 1964 · S/N 326N6966VBullard Joseph · Saint Louis, MOBuilt 1976 · S/N 22-1333N6966WYoumans Elbert Mitchell · Waynesboro, GABuilt 1965 · S/N 28-21163N6967CUp And Down Aviation LLC · Perry, GAS/N 28-7816444N6967RGunnarsson Jon · Concrete, WABuilt 1975 · S/N M-1617N6967UEstey Richard H · Thomson, GABuilt 1964 · S/N 327N6967VMile High Air LLC · Holland, MIS/N 22-1334N6967WBengis Adam · Seattle, WABuilt 1965 · S/N 28-21164N6968PFoos LLC · Vancouver, WABuilt 1960 · S/N 24-2109N6968UFowler Craig A · Chireno, TXBuilt 1964 · S/N 328N6968VArnold Norman K · Fayetteville, ARBuilt 1976 · S/N 22-1335N6968WMidgard Aviation LLC · Colton, SDBuilt 1965 · S/N 28-21165N6969BBrown Dennis K · Reno, NVBuilt 1978 · S/N 2172N6969HGittlein Matthew P · Wasilla, AKBuilt 1974 · S/N 18-7409061N6969PHart Richard W · Alexandria, VABuilt 1960 · S/N 24-2111N6969UBurdak Erik · Mound, MNBuilt 1964 · S/N 329N6969VArcher II Management LLC · Hernando, MSBuilt 1979 · S/N 288090137N696APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843783N696AGWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261326N696AKSloans Aircraft Welding LLC · Anchorage, AKBuilt 1996 · S/N 1533N696ARDreamcatcher Aero LLC · Austin, TXBuilt 2017 · S/N 003N696DBRobinson Michael C · Lakeland, FLBuilt 1996 · S/N 11083N696DGFonseca Joseph K · Northlake, TXBuilt 2005 · S/N 18089CN696DWDelta Whiskey LLC · Huron, SDBuilt 1967 · S/N 32-968N696DYInline Developers LLC · Wilmington, DEBuilt 1997 · S/N 25007CN696EAHubbard Broadcasting Inc · Saint Paul, MNBuilt 2005 · S/N 18281722N696FGPro LLC · Gassaway, WVBuilt 2002 · S/N 60181N696FLGood Joseph A · Weymouth, MABuilt 1971 · S/N 28-7125635N696HDDylag Andrew J · Cold Spring, NYS/N 22481N696HJCold Rain Inc · Carleton, NEBuilt 1979 · S/N 28-8090190N696JANational Industrial Services LLC · Kingshill, VIBuilt 1965 · S/N 27-2924N696LBN&C Aviation LLC · Niles, MIBuilt 1964 · S/N 28-20136N696LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881629N696MLAdventuresplash LLC · Ponte Vedra Beach, FLS/N 3RX022N696NGiles Forrest D · Springtown, TXS/N 1-AN696PGreer James E Jr · Summit Point, WVBuilt 1960 · S/N 24-1718N696RCastro Wladimir · Carolina, PRBuilt 1976 · S/N 17267360N696RJWeitman Jim Trustee · Decatur Island, WAFirst renewal noticeBuilt 1953 · S/N 18-3363N696RKClassic Aviation Inc · Pella, IABuilt 1992 · S/N 20193N696SAThree Green Aviators LLC · Midland, TXBuilt 2000 · S/N 18280845N696SHGurry Deirdre M · Pt Pleasant, NJBuilt 2004 · S/N 22755N696SPMj Paws LLC · Wilmington, DEBuilt 1997 · S/N 791-97N696WWinnick Richard E · Denver, COBuilt 2001 · S/N 002
Back to AD 87-10-06 R1