OpenAirDocs.org
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.

N5260WNance James B · Terrell, TXBuilt 1962 · S/N 28-305N5261PMon-Dak Consulting Inc · Plentywood, MTFirst renewal noticeBuilt 1958 · S/N 24-297N5261UBackus Gary Carl · Chesapeake, VABuilt 1980 · S/N 172RG0308N5262HBun Air Corp · Bedford, PABuilt 1975 · S/N 17265388N5262LWilliams Gregory L · Tehachapi, CABuilt 1967 · S/N 28-4560N5262SSalls Robert A · Glen Mills, PABuilt 1971 · S/N 32-7140040N5262TSmith Gregory W · Laurel, MDBuilt 1972 · S/N 28R-7235210N52635Allard Michael · Penrose, COS/N 17274573N5263BFerland Erik · Everett, MABuilt 1957 · S/N 1126N5263LRjl Aero Inc · Valparaiso, INBuilt 1967 · S/N 28-4561N5263TBackroads Aviation LLC · Holdrege, NEBuilt 1972 · S/N 32-7240102N5263WCjco Holdings LLC · Venus, TXBuilt 1962 · S/N 28-309N5264DPironti Bennett D · Long Valley, NJS/N 17272481N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036N5264PBohmer James F · Tulsa, OKS/N 24-300N5264WGray Donald B Trustee · Houston, TXBuilt 1961 · S/N 28-310N5264XTank David M · Cambridge, OHBuilt 1969 · S/N 170N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576N52657Honeycutt Holdings Inc · Charlotte, NCS/N T18208172N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804N5265RMoss Hill Airport Inc · Kinston, NCBuilt 1974 · S/N 17263479N5265SEagle Aeronautics LLC · Chicago, ILBuilt 1971 · S/N 32-7140044N5265WDwight Marketing Corporation · Caldwell, KSBuilt 1962 · S/N 28-311N5265XSwanton Peter K · Willits, CABuilt 1969 · S/N 124N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805N5266KCorsicana Aviation Training Services LLC · Corsicana, TXBuilt 1980 · S/N 17274037N5266SFogle Cooper · Mooresville, NCBuilt 1971 · S/N 28R-7135120N5266UN5266u LLC · Brookfield, ILBuilt 1980 · S/N 172RG0312N5266WMichigan Sport Aviators Inc · Midland, MIBuilt 1962 · S/N 28-312N5266XKrabbenhoft J F · Amenia, NDBuilt 1969 · S/N 191N52671Carver Aero LLC · Muscatine, IABuilt 1981 · S/N 17274577N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806N5267LBlasi Aviation LLC · Valley Center, KSBuilt 1967 · S/N 28-4565N5267PCarter Jeffrey Lee · Cameron Park, CABuilt 1958 · S/N 24-303N5267SAviation Psych LLC · Neptune Beach, FLBuilt 1980 · S/N R18201530N5267XShelden Seth · Palmer, AKBuilt 1969 · S/N 192N52683Cobb John Mark · Fayetteville, TNBuilt 1981 · S/N 17274579N52685Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274580N5268BCabbage David A · Colville, WABuilt 1957 · S/N 1131N5268HGrander Aviation LLC · Panama City Beach, FLBuilt 1975 · S/N 17265389N5268JReach For Skies LLC · San Antonio, TXBuilt 1980 · S/N 17273751N5268KSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 17274038N5268RJohnson Steven D · Oklahoma City, OKS/N 17263482N5268TDykes Don A · Houston, TXBuilt 1972 · S/N 28-7205252N52694Sullivan Michael E Trustee · Granite Bay, CABuilt 2002 · S/N 18281161N5269LKarel John · Stillwater, MNBuilt 1967 · S/N 28-4567N5269SCanyon Blue LLC · Sharpsburg, GABuilt 1980 · S/N R18201531N5269TKailua Aviation LLC · Moorestown, NJBuilt 1972 · S/N 28-7205253
Back to AD 87-10-06 R1