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.

N6668QRegistered aircraftBuilt 1983 · S/N E-2077N6669XEdm-Van LLC · Maple Lake, MNBuilt 1979 · S/N TK-108N666CNHamon John · Paso Robles, CABuilt 1979 · S/N E-1470N666WCAnderson Brian · Fresno, CABuilt 1977 · S/N TE-1087N666WFFehlhaber Wolfgang M · Port Orange, FLBuilt 1976 · S/N D-9885N666WLM Holdings Aero LLC · Wilmington, DES/N E-2216N6670GSterling Park Corp · Ashland, KYBuilt 1979 · S/N EA-26N6670JMccracken Scott D · Maysville, OKBuilt 1979 · S/N D-10295N6670ZMortan Robert F · Mckinney, TXBuilt 1979 · S/N E-1585N66719Dusch William C · Concord, NCBuilt 1983 · S/N E-2078N6671DGruber Mark W · Edmond, OKBuilt 1979 · S/N E-1613N6671LArias Aviation Inc · Wilmington, DEBuilt 1983 · S/N E-2079N6671XDairy Air LLC · Mount Crawford, VABuilt 1979 · S/N TH-1077N66722Lumpkin Ed · Rosie, ARS/N E-2081N6672BYour World Inc · Draper, UTBuilt 1979 · S/N E-1584N6672KMaremy LLC · Ramona, CABuilt 1979 · S/N E-1564N6672XInpatient Services Association LLC · Floyds Knobs, INBuilt 1979 · S/N EA-32N6675ATool Equipment Leasing Corporation · Bethany, OKBuilt 1979 · S/N EA-30N6675LMcelhannon Fayette M Jr · Athens, GABuilt 1979 · S/N CE-882N6675YField Inspection LLC · Brawley, CABuilt 1980 · S/N TJ-254N6677LAeropacific Consulting LLC · Reno, NVBuilt 1979 · S/N TJ-209N6677YBrown Hunter L · Sulphur Rock, ARBuilt 1979 · S/N E-1594N66784Grimm Phillip H · Draper, UTBuilt 1979 · S/N EA-34N6678C678c LLC · Pensacola Beach, FLBuilt 1979 · S/N TJ-235N6678SHawkeye Aero Sales LLC · West Des Moines, IABuilt 1976 · S/N CE-628N6678YNewhouse Eric · Corrales, NMBuilt 1983 · S/N EA-360N6679APegasus Specialty Leasing Inc · Paris, TXBuilt 1983 · S/N E-2082N6679XElite Aviation Group LLC · Pasco, WABuilt 1982 · S/N E-2041N6679YRanchlands LLC · Hyattville, WYBuilt 1988 · S/N E-2445N667DBGutierrez Jess R · Portland, ORBuilt 1977 · S/N CE-737N66801Cirrus Management LLC · Suwanee, GABuilt 1979 · S/N E-1603N66805Opa Aviation LLC · Littleton, NCBuilt 1980 · S/N TH-1081N6680GHorst Commercial Ventures LLC · Sanger, TXBuilt 1979 · S/N TJ-236N66812Dehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1604N66815Circle S Aviation LLC · Missoula, MTS/N E-2083N66818Schultz Gregory L · Greenbush, MNS/N D-10310N6681LRotary Industries Inc · Miami, FLBuilt 1979 · S/N TH-1088N6682ZDavis Brad L Trustee · Canton, MOBuilt 1979 · S/N E-1607N6683DRegional Consultants LLC · Wilmington, DEBuilt 1979 · S/N D-10311N6683NLn Skies LLC · Streetman, TXBuilt 1979 · S/N TJ-239N6683YGate Post Aviation LLC · Woodbury, CTBuilt 1979 · S/N TK-111N66840Lowery Aviation LLC · Burwell, NEBuilt 1983 · S/N E-2085N66844Munden Paul M · Amarillo, TXS/N EA-364N66849Hawk Aircraft Sales And Leasing LLC · Sterling Heights, MIBuilt 1979 · S/N TH-1092N6684DDowney Leasing LLC · Lexington, NEBuilt 1979 · S/N E-1610N6684VFba Leasing LLC · Mountain Brk, ALS/N TH-1089N6685RGlobal Distillation Services LLC · Reno, NVBuilt 1979 · S/N D-10314N66863Taylor John Arthur · Mission Hills, KSBuilt 1983 · S/N E-2086N6686DN6686d LLC · Idaho Springs, COBuilt 1979 · S/N TH-1097N6686GDarco Hotels Inc · Bentonville, ARBuilt 1981 · S/N EA189
Back to AD 87-18-06 R1