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.

N9077JStreuer Troy · Smithville, TXBuilt 1966 · S/N 28-3113N9077KPacific Coast Aero Inc · Torrance, CABuilt 1977 · S/N 28-7816188N9077LVeilleux Payton L · Pittsfield, VTBuilt 1970 · S/N 264-71N9077PFarris James E · Brentwood, TNFirst renewal noticeBuilt 1966 · S/N 24-4546N9077WSmith Dwayne · Manassas, VAS/N 28-10677N90783Rudd Wayne G · Basalt, COBuilt 1982 · S/N 0290N9078DChandelle Ltd · Brighton, COBuilt 1958 · S/N 18-6446N9078JConner W Larry · Los Lunas, NMBuilt 1966 · S/N 28-3115N9078VRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1968 · S/N 690002N9078WWood Trey A · Colorado City, TXS/N 28-10678N9078YParker Ron L · Melissa, TXBuilt 1970 · S/N 18-8908N9079DThomas William C · Blanchardville, WIBuilt 1958 · S/N 18-6447N9079JTestruth Gary R · Coarsegold, CABuilt 1966 · S/N 28-3116N9079NFlorida State College At Jacksonville · Jacksonville, FLBuilt 1982 · S/N 0295N9079PTyrrel David E · Harlan, IABuilt 1966 · S/N 24-4549N9079TLuther David J Trustee · Saint Maries, IDBuilt 2001 · S/N 001N9079VAbramson Derek J · Lancaster, CABuilt 1968 · S/N 690003N907AGAntique Aircraft And Automobile LLC · Van Alstyne, TXS/N 22-7218N907APWheeler David A · Kennewick, WAS/N AG5B-10001N907AXNeuman Cort J · Palmer, AKBuilt 2022 · S/N 1N907AZN907az LLC · Miami, FLBuilt 1980 · S/N 17274436N907BPBryant Stephen C · Anchorage, AKS/N 22-2431N907BTKramer Michael · Talkeetna, AKBuilt 2015 · S/N 072515N907CCOconnor Lloyd Thomas · Dillingham, AKS/N 9907CCN907CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8330N907CUDenny Roger A Jr · Eagle River, AKBuilt 2016 · S/N 02-1988N907DTLanni Douglas W · Fairbanks, AKBuilt 2022 · S/N 0001N907FVGuthrie Richard A · Anchorage, AKBuilt 1955 · S/N 18-4387N907GDAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 340N907GJKincaid Levi L · Palmer, AKBuilt 2023 · S/N 221N907GPGittlein Paul A · Wasilla, AKBuilt 2010 · S/N 001N907HHarding Jason I · Wasilla, AKBuilt 2018 · S/N 001N907HGDenali North Side Adventures LLC · Wasilla, AKBuilt 2005 · S/N 10790N907HRMerrill Andrew T · Bethel, AKBuilt 2011 · S/N 100N907JConaway Jeffrey Scott · Anchorage, AKBuilt 1965 · S/N 18-8259N907JAAnderson James C · Wasilla, AKFirst renewal noticeBuilt 2020 · S/N JA001N907JSStevenson William E · Sutton, AKBuilt 2015 · S/N 2406N907KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268575N907KYYoung Richard H · Eagle River, AKBuilt 2023 · S/N RY001N907LEAll Her Fault LLC · Fairbanks, AKBuilt 2004 · S/N 3623N907LJAgl Aero LLC · Mckinney, TXBuilt 1969 · S/N 30-1862N907LLAerial Ag Services LLC · Hillsboro, TXBuilt 2006 · S/N 11184N907LPMicro Publishing Press Inc · Truckee, CABuilt 1999 · S/N 172S8221N907MWaitman Bradley J · Wasilla, AKBuilt 2020 · S/N 001N907PKBachus James Ross · Stephenville, TXBuilt 2010 · S/N 91168N907PMMinelga Paul · Soldotna, AKBuilt 2024 · S/N 708N907PSBrock W Walker · Charleston, SCBuilt 1966 · S/N 28-3762N907RDLynch James P · Santa Barbara, CAS/N 82088N907RFFinch Robert C · Anchorage, AKBuilt 2024 · S/N 001N907RUBlahut Michael · Anchorage, AKBuilt 1950 · S/N 18-192
Back to AD 87-10-06 R1