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.

N901TGWestland Aviation LLC · Lake Havasu City, AZBuilt 1968 · S/N 17257312N901TQAdirondack Aviation LLC · Saranac Lake, NYBuilt 1977 · S/N 28-7725178N901TTEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2002 · S/N 10024N901VWAviation Business Corp · Saint Louis, MOS/N 27-2101N901WHAlpha Helicopters LLC · Lewes, DEBuilt 2008 · S/N 1921N901XZTaylor James A · Memphis, TNBuilt 1977 · S/N 18-7809044N901ZBraddock Zachary J · Ladson, SCBuilt 1987 · S/N 5125N9020DBaker Donald W · China Spring, TXFirst renewal noticeBuilt 1958 · S/N 22-6169N9020PLindsay Terry M · West Hills, CABuilt 1966 · S/N 24-4482N90214Market Garden Corp · Wilmington, DEBuilt 2005 · S/N 60540N9021LRobert Rees · Jonesboro, ARS/N 214-70N9021PFontenot Monty Jason · Aiken, SCBuilt 1966 · S/N 24-4483N9021WHage Electric And Construction Services Inc · The Dalles, ORBuilt 1966 · S/N 28-10819N9022JLewis Kristofor M · Sparks, NVBuilt 1966 · S/N 28-3050N9022PAcc Air Charter Company · Wilmington, DEBuilt 1966 · S/N 24-4484N9023DCarberry David H · Stockton, UTBuilt 2004 · S/N 5897N9023JCook Richard J II · Princeton, ILBuilt 1966 · S/N 28-3051N9023LLammers David T · Bonney Lake, WABuilt 1970 · S/N 246-70N9023MBrandis Robert J · Taylorville, ILS/N 2020N9023PHand Joseph Michael · Sheboygan Falls, WIBuilt 1966 · S/N 24-4485N90249Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0039N9024PBlue Skies Above LLC · Bogart, GABuilt 1966 · S/N 24-4486N90253Wood Roger Weaver · Sale Creek, TNBuilt 1972 · S/N 27-4779N9025JAa&R Aviation LLC · Pine Grove, PABuilt 1966 · S/N 28-3053N9025PIdeation Machine LLC · Las Vegas, NVS/N 24-4487N9025WCarlson Joshua G · Frazee, MNBuilt 1965 · S/N 28-10613N9026DCuthbertson Steven M · Van Alstyne, TXBuilt 1958 · S/N 22-6163N9026JRay Adam W · Stinnett, TXBuilt 1966 · S/N 28-3054N90270Dunn Larry W · Anderson, SCBuilt 1966 · S/N 66-18283N90271Gartman Jerald B · Morehead City, NCBuilt 1965 · S/N 65-18261N9027EShield Raymond C · Russell, PABuilt 1977 · S/N 7074CN9027FErickson Jon D · Atwater, MNBuilt 1976 · S/N 28-7715299N9027HAdriatic Holdings LLC · Cheyenne, WYS/N 17265908N9027WAg Air Squadron One LLC · Saint Joseph, ILBuilt 1965 · S/N 28-10617N9028JGarcia Pinedo Adolfo · Miami, FLBuilt 1966 · S/N 28-3055N9028PBray Nick R Trustee · China Spring, TXBuilt 1966 · S/N 24-4490N9029LMarracino Services LLC · Deland, FLBuilt 1970 · S/N 258-70N9029PEzzell Stephen Mark · Statesville, NCS/N 24-4491N9029YJohnson Scott W · Saline, MIBuilt 1970 · S/N 18-8905N902APPollard Aircraft Sales Inc · Fort Worth, TXBuilt 1998 · S/N 18280306N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091N902CWhite Edwin W · Eagle River, AKBuilt 2001 · S/N 2162N902CCVan Flve Klub Inc · Holt, MNS/N 9902CCN902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174N902GRWright Allan M · Los Gatos, CABuilt 2002 · S/N 2411N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530N902SAWild Wings Aviation Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N SH001
Back to AD 87-10-06 R1