OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N6385UHilde Chadwick Q · Memphis, TNBuilt 1982 · S/N EA-290N6387UWeyermuller Scott P · Bossier City, LAS/N EA-291N6388PMurfin Drilling Co Inc · Wichita, KSBuilt 1981 · S/N E-1991N6389UBender & Lammers LLC · Bennington, NEBuilt 1982 · S/N EA-294N638LDDion Aviation LLC · Key West, FLBuilt 1976 · S/N TH765N638PClements Scott · Royse City, TXBuilt 1981 · S/N EA-209N638WCBrown Everette · Edenton, NCBuilt 1975 · S/N TH-632N63936Sea & Ski Nw LLC · Portland, ORBuilt 1982 · S/N E-2053N6393SRegistered aircraftBuilt 1975 · S/N CE-623N6397SIts Allgood Air LLC · Lewes, DEBuilt 1975 · S/N D-9833N639ARBraden Health LLC · Greensboro, NCBuilt 2000 · S/N TH-1968N63BHN63bh LLC · Auburn, ALBuilt 1977 · S/N E-1186N63BMDayton Aircraft Services Inc · Daytona Beach, FLS/N E-3410N63BRLevel Up Capital LLC · Roswell, GAS/N E-3061N63JLStoneman Thomas K · Friendswood, TXBuilt 1971 · S/N TE-839N63JMBeer Galynn W · Dewitt, MIBuilt 1980 · S/N EA-80N63JNDesert Air Inc · Phoenix, AZBuilt 1997 · S/N EA602N63TMartin Sky LLC · Beaufort, SCBuilt 1975 · S/N E-703N63TCRegistered aircraftBuilt 1972 · S/N E-384N63TLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2000 · S/N E-3307N6401HBooskye LLC · Dumas, TXBuilt 1981 · S/N TJ-401N6407XRobert G Whittel P A · Gainesville, FLS/N EA-295N6408QAftershock Marketing Inc · Henryville, PABuilt 1982 · S/N TJ-408N64098Sottile Joseph Jr Trustee · Chandler, AZBuilt 1978 · S/N D-10128N6409SWas He Slow LLC · Chagrin Falls, OHBuilt 1976 · S/N D-9838N640ACPlane Old LLC · Wildwood, MOBuilt 1974 · S/N TH-458N640MCConston Kenneth M · Hopewell Junction, NYBuilt 2001 · S/N EA-682N6412XFucaimo LLC · South Pasadena, CAS/N TJ-412N6416NMcdonald Marshall H · Saint Petersburg, FLBuilt 1982 · S/N E-2043N641GWalrabenstein Eric S · Glendale, AZBuilt 1976 · S/N D-9896N64200D&G Baron LLC · Helena, ARBuilt 1982 · S/N TJ-420N6428SWickboldt Michael P · Woodland, CABuilt 1976 · S/N D-9842N642GInguagiato Thomas · Hood River, ORBuilt 1987 · S/N E-2372N6444CNichols Christian Travis · Rio Rancho, NMBuilt 1982 · S/N EA-275N6449NBaumann Richard A Trustee · Tempe, AZBuilt 1982 · S/N EA-298N644BLGahan Matthew · San Clemente, CABuilt 1989 · S/N EA492N6453CSale Reported · Miller, SDSale reported, pending cancellationS/N EA-277N6455NHangar 31 Inc · La Jolla, CABuilt 1973 · S/N CE-424N6456CWab Enterprises Inc · Fountain Hills, AZBuilt 1982 · S/N EA-303N6458CMb/F Inc · Greensboro, NCBuilt 1985 · S/N TH-1495N645SKBendavid Gary · Oak Bluffs, MAS/N TH-2118N64609Sr Aviation LLC · Pocola, OKBuilt 1982 · S/N E-2055N6464APerry Scott · Flower Mound, TXBuilt 1982 · S/N EA-330N6465GD Luckie LLC · Kalispell, MTBuilt 1982 · S/N EA-305N6467NDa Vinci Aero LLC · Lake Ozark, MOBuilt 1982 · S/N EA-310N6467XScottfree Aviation LLC · West Palm Beach, FLBuilt 1982 · S/N E-2056N646TTango Charlie LLC · San Leon, TXBuilt 1974 · S/N TE-981N6476ZVorlop Robert W · Delray Beach, FLBuilt 1982 · S/N EA-311N64793N64793 LLC · Naples, FLBuilt 1982 · S/N E-2057N6484L6484l LLC · Denver, COBuilt 1982 · S/N EA-313
Back to AD 87-18-06 R1