OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,003

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.

N116GSTharp Thomas J · Nampa, IDBuilt 2001 · S/N 1298009N116GWMajestic Airlines Inc DBA · Lynden, WABuilt 1970 · S/N 31-662N116JMMorgan James E · Everett, WABuilt 2009 · S/N RV20260N116JTParks Kevin J · Arlington, TNBuilt 2009 · S/N 80982N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820N116LTMarrow Henry G · Southern Pines, NCBuilt 2013 · S/N 6090N116MFWeber Donald E · Saint David, AZS/N 27-3522N116MRDibuono Michael · Clearwater, FLBuilt 2025 · S/N 0700N116NJUsda Forest Service Fepp · Trenton, NJBuilt 1964 · S/N 18-8104N116PCGlobal Piloting Solutions LLC · Mankato, MNBuilt 2001 · S/N 1320-2001N116PGUnusual Attitudes LLC · Bates City, MOBuilt 2004 · S/N 3547N116QCigarroa Jorge J · Laredo, TXBuilt 1997 · S/N 1360N116RCMiesch Gary D · Gowen, MIBuilt 1976 · S/N 14061N116RVJordan Jimmy W · Winnfield, LABuilt 1999 · S/N 60136N116SDA L Aviation LLC · Boiling Springs, SCS/N 359-73N116SLXcel Aviation LLC · Eagle, IDBuilt 2003 · S/N 18281242N116SMArchie Aero LLC · Beaverton, ORBuilt 2005 · S/N T18208426N116TBMcmullan Francis G · Weirsdale, FLS/N 362N116TSIrish Cindy L · Buckeye, AZBuilt 2003 · S/N 60399N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346N116VKAirborne LLC · Wilmington, DEBuilt 2018 · S/N 2547N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042N11702Tailwheeling It LLC · Algoma, WIBuilt 1972 · S/N 317-72N11706Hershberger Brian K · Wrightwood, CABuilt 1972 · S/N 319-72N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72N1170JHoward Thomas D · Bunnlevel, NCBuilt 1974 · S/N 170N1170LSweet Aviation LLC · Dover, DES/N 332N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670N1171CUnser Joshua D · Anchorage, AKBuilt 1953 · S/N 20-963N11721Yague-Martinez Eloy · Rochester, NYBuilt 1972 · S/N 320-72N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672N1172PSteed William B · Winnsboro, SCS/N 23-175N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679N1173JCohelios LLC · Oviedo, FLBuilt 1974 · S/N 135N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379N1173YSorg Daniel T · Columbus, INS/N 001N1174JOlson Michael J · Viroqua, WIBuilt 1974 · S/N 174N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188N11756Creswell Philip M · Camden, ALBuilt 1975 · S/N 17702365N1175ABurmeister Aaron R · Nenana, AKBuilt 1951 · S/N 18-777N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77N1176EIrving Holdings LLC · Greensboro, NCBuilt 1977 · S/N 988-77N1176RBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 18281688N1176TP C O Leasing Inc · Dobbin, TXBuilt 2005 · S/N 18281587N1176UPlane Leasing LLC · Wilmington, DEBuilt 1976 · S/N 17266877N1176ZAirborne Support Inc · Bourg, LABuilt 1965 · S/N 500-B-1549-196
Back to AD 87-10-06 R1