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.

N49307Lutes David W · Berryton, KSBuilt 1981 · S/N 1002N49309Newton Thomas L Jr · Fredericksburg, VABuilt 1982 · S/N 1006N4930LG Salisbury & Associates Inc · Prescott, AZBuilt 1967 · S/N 28-4297N4930PRegion Flyers LLC · Valparaiso, INS/N 27-523N4930UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842241N49312Boyd Timothy · East Point, KYBuilt 1982 · S/N 1008N49314Losacker Matthew S · Chandler, AZBuilt 1983 · S/N 1014N49315Morphew Ben · Mckinney, TXS/N 1013N49319Anderson Richard P · De Leon Springs, FLBuilt 1985 · S/N 1029N4931LThrust Spear Of Tampa LLC · Tampa, FLBuilt 1967 · S/N 28-4299N4931WPerry Clifton · Lacon, ILBuilt 1977 · S/N 14254N4932JDunlap Aviation Inc · Dunlap, ILBuilt 1968 · S/N 28R-30653N4932SThunder Aviation LLC · Oro Valley, AZBuilt 1980 · S/N R18201471N49330Cjw Hydrodynamics Inc · Fresno, TXBuilt 1986 · S/N 1035N49331Plane Fun Inc Tr Trustee · Snellville, GAS/N 1038N49332Blue Eagle Pitts LLC · Tempe, AZS/N 1039N49335Van Cleave Raymond D · Kalispell, MTBuilt 1986 · S/N 5102N49336Krieger Heinz Friedrich · FrenkendorfS/N 1045N49337Herrmann Ralf D · DahlemBuilt 1986 · S/N 1046N49338Bakker Matthew G · Ellington, CTBuilt 1986 · S/N 1044N49339Goble John H · Cresson, TXBuilt 1987 · S/N 1047N4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationBuilt 1968 · S/N 28R-30654N4933LSouthall Charles B · Amelia, OHS/N 28-4301N4933SHedden Larry H · Huntsville, ALBuilt 1980 · S/N R18201334N49340Butler Tracey D · Buckley, WABuilt 1987 · S/N 1048N49347Bryant Otto LLC · Conway, ARBuilt 1991 · S/N 1190N49348Benner Tristen · Opheim, MTBuilt 1991 · S/N 1194N49349Rankin Ty · Amarillo, TXBuilt 1991 · S/N 1196N4934FAffordale Aviation Corp · Moriches, NYBuilt 1976 · S/N 28-7715082N4934LFlyboys LLC · Orange, VABuilt 1967 · S/N 28-4302N4934PAlm Holding LLC · Winton, CABuilt 1963 · S/N 27-527N4934SFerrell Charles A · Stockton, CABuilt 1980 · S/N R18201473N4934WS&T Aircraft LLC · Lewes, DEBuilt 1977 · S/N 14256N49353Skye Equipment LLC · Asheboro, NCBuilt 1992 · S/N 1217N49354Staple Three Sheep Co · Midwest, WYBuilt 1991 · S/N 1199N49357Miller Blaine Nathan · Brooks, GABuilt 1992 · S/N 1223N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482N4935LCurnutt Aviation LLC · Fort Stockton, TXBuilt 1968 · S/N 28-5127N49362Schubert Paul · Raleigh, NCBuilt 1992 · S/N 1221N49363Back Country Aviation LLC · Kalispell, MTBuilt 1993 · S/N 1234N49365Mcdonald Ryan James · Chelan, WAS/N 1250N49366Kellogg John H · Skaneateles, NYBuilt 1994 · S/N 1257N4936LBluse James · Bethlehem, GABuilt 1967 · S/N 28-4304N4936TDakma LLC · Parma, OHBuilt 1981 · S/N R18201794N49370Powell Weston G · Washoe Valley, NVBuilt 1994 · S/N 1273N49371Hebert Max C · Hartstown, PABuilt 1995 · S/N 1277N49372Walker Scott E · Fort Collins, COBuilt 1995 · S/N 1284N4937FRegistered aircraftBuilt 1976 · S/N 28-7790075N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484N4937SRauch James A III · Cayce, SCBuilt 1980 · S/N R18201476
Back to AD 87-10-06 R1