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.

N35TBCencalcom Inc · Santa Barbara, CABuilt 1977 · S/N D-9985N35TDShelton Aviation LLC · Salem, ORBuilt 1993 · S/N EA-555N35TEOusley James Dean Jr · Granbury, TXBuilt 1979 · S/N E-1550N35TJBeech D9462 LLC · Perry, OHBuilt 1973 · S/N D9462N35TPMccallister Mark A · Qulin, MOBuilt 1977 · S/N D-10018N35VBEquipment Lessors Inc · Lake Hawatha, NJBuilt 1977 · S/N D-10000N35YRTonini Farm And Cattle Co · San Luis Obispo, CABuilt 1982 · S/N D-10397N360AStrong LLC · Norcross, GABuilt 1981 · S/N E-1904N360NEGoldrivet · Stateline, NVBuilt 1980 · S/N EA-128N360PMBon Aire Inc · Middlesboro, KYBuilt 1978 · S/N E-1253N360UAdrenalyne Consulting LLC · Scottsdale, AZBuilt 1997 · S/N TH-1834N3611ASgmbb LLC · Seneca, SCBuilt 1979 · S/N E-1472N361AHHodge Cleophas U · St Thomas, VIBuilt 1980 · S/N TJ-308N361CMMesser-Bowers Co · Enid, OKBuilt 1986 · S/N E-2312N361CWCk Aviation LLC · Brookhaven, MSBuilt 1980 · S/N E-1755N361DMLeibstein Guy · Babylon, NYBuilt 1975 · S/N E-670N361KWFliteco Holdings LLC · Lewes, DEBuilt 1981 · S/N EA-264N361WHubbard Kenneth Scott · Decatur, ALBuilt 2002 · S/N E-3438N3621RBateman Randy · Lindale, TXBuilt 1977 · S/N E-1095N3622AWing Bird Aviation LLC · Garland, TXBuilt 1969 · S/N TE-777N3622TShaw Aviation LLC · Greenleaf, IDBuilt 1974 · S/N TH-479N3627AHint Mart H · Peachtree City, GABuilt 1969 · S/N D-9079N3629ADarrow Mark A Trustee · Mukilteo, WABuilt 1969 · S/N D-9080N362ARegistered aircraftBuilt 1980 · S/N E-1745N362DLBee Line LLC · Millwood, GABuilt 1992 · S/N TH-1653N362RMAmerican Aviation Inc · Brooksville, FLBuilt 1984 · S/N E-2194N362SAScapha Air LLC · Boone, NCS/N E-3517N362SBNilco Enterprises Inc · Irving, TXBuilt 1981 · S/N E-1848N362TBarnett Blake C · Boynton Beach, FLBuilt 1977 · S/N D-10025N3632APauly Adam · Macomb, MIBuilt 1969 · S/N D-9081N36363Klein John · Woodland, CABuilt 1975 · S/N D-9748N3636AScull Adam C · Hockessin, DEBuilt 1978 · S/N E-1399N3636TFortier Stanley · Chico, CAS/N EA-18N363BCBig Cha Inc · Wilmington, DES/N D-9763N363KBTriple F LLC · Dixon, ILBuilt 1996 · S/N E-3000N363MBCohen Greg · Gaithersburg, MDBuilt 1997 · S/N E-3143N364ACWalker Geri G · Carrollton, GABuilt 1998 · S/N E-3148N364BBSocio Aviation Services LLC · Benton, KYBuilt 1999 · S/N E-3240N364BFFlying B Partners LLC · Wichita, KSBuilt 1977 · S/N E-1166N364BGBehrens Julie A · Crested Butte, COS/N E-3559N364DBHirsch Benjamin M · Orange Park, FLBuilt 1995 · S/N E-2963N364DDJd Bonanza LLC · Mesa, AZBuilt 1996 · S/N E3056N364DFBlackley Nathan · Eugene, ORBuilt 1997 · S/N E-3091N364ELFiorini Randy · Turlock, CABuilt 1988 · S/N CE-1268N364GGTddc Ventures LLC · Dublin, CABuilt 1990 · S/N EA-501N364HPZadeh Alidad Trustee · El Centro, CABuilt 1973 · S/N E-402N364JBBlazie Marketing Services Inc · Street, MDBuilt 1997 · S/N E-3079N364PJ L Garred Sr Mdpc · Whiting, IABuilt 1995 · S/N EA-578N364SCTfs Inc · Chelsea, ALBuilt 2001 · S/N E-3374N364SSLampert David M · Atherton, CABuilt 1992 · S/N EA-542
Back to AD 87-18-06 R1