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.

N8171RYankee Air Pirate LLC · Memphis, TNBuilt 1974 · S/N D-9669N8171ZRidgeline LLC · Helena, MTBuilt 1993 · S/N E-2785N8172RDerby City Aviation LLC · Vero Beach, FLBuilt 1974 · S/N TH-515N8173CJet Pros LLC · Scottsdale, AZBuilt 1990 · S/N CE-1541N8173RAdkins Douglas E · Klamath Falls, ORBuilt 1974 · S/N E-593N8178RW L Landess LLC · Guymon, OKBuilt 1974 · S/N E-594N817CAFaze3 Partners LLC · Kalispell, MTS/N E-1724N817LAUnger William · Missouri City, TXBuilt 1994 · S/N E-2852N817NMWest Bound Hound LLC · Sheridan, WYBuilt 1979 · S/N EA-27N817RMOmega Metals Inc · Douglasville, GABuilt 1981 · S/N EA-203N8181VPebble Alternative LLC · Harahan, LABuilt 1991 · S/N E-2610N8183EGuardado Rodolfo · Sun Valley, CABuilt 1991 · S/N E-2612N8183RFerriolo Donald J · Greer, SCBuilt 1974 · S/N D-9671N8184NB & S Holdings LLC · Augusta, GABuilt 1991 · S/N E-2648N8185RMiles Timothy Neil · Tampa, FLBuilt 1974 · S/N E-595N8187RFleck Richard N Trustee · Camarillo, CABuilt 1974 · S/N D-9673N818DBBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1978 · S/N E-1342N818LARegistered aircraftBuilt 1994 · S/N E-2868N818PDesmet Paul F · Mercersburg, PABuilt 1986 · S/N E-2352N818PRMalus Flyers LLC · Henderson, NVBuilt 2001 · S/N E-3397N818RMB And D Solutions LLC · Billings, MTBuilt 1978 · S/N TE-1150N818RRRich Thomas M · Pittsboro, INS/N E-3543N8190GSchubert Jackie E Jr · Jamestown, TNS/N E-2658N8191KSummerfields Animal Hospital Pllc · Fort Worth, TXBuilt 1991 · S/N E-2662N8191RM B Duncan Inc · Bakersfield, CABuilt 1974 · S/N D-9675N8192RStarr Aviation LLC · Birmingham, ALBuilt 1974 · S/N E-598N8195JJani-King Int'L Inc · Addison, TXBuilt 1993 · S/N E-2789N8196RSchwab Robert · Austin, TXBuilt 1974 · S/N TE-1002N8198BOrmont Michael L Trustee · Poughkeepsie, NYBuilt 1991 · S/N CE-1637N8198MGokul LLC · Landrum, SCBuilt 1993 · S/N E-2787N8198TBuilding Swell LLC · New York, NYBuilt 1993 · S/N CE-1723N819BRooney William T · Lakin, KSBuilt 1978 · S/N D-10186N819DKBankston David P · Horseshoe Bay, TXBuilt 1983 · S/N EA-387N819DMPottier Michael John · Dover, NHS/N EA-456N819LAMukherjee Jason S Trustee · Simi Valley, CABuilt 1994 · S/N E-2869N819LBBowles Jeffrey D · Fitchburg, WIBuilt 1977 · S/N E-1126N819T3rd Gen Aviation LLC · Lisbon, NDBuilt 1973 · S/N D-9507N81AJAircraft Propulsion Leasing LLC · Holland, OHBuilt 1976 · S/N TK-12N81BBDunigan Patrick J · Jackson, MIBuilt 1973 · S/N CE-449N81CLGlassman Aaron · Virginia Beach, VABuilt 1981 · S/N TH-1296N81DDJdj Transport LLC · Wilmington, DEBuilt 1980 · S/N TH-1212N81DLLewis Donald C · Winters, CABuilt 1977 · S/N E-1156N81DRCommonwealth Aviation Service Inc DBA · Richmond, VABuilt 1978 · S/N TH-971N81FGBrandis Robert DBA · Taylorville, ILS/N E-2424N81HBMinard Patricia J · Cheney, KSBuilt 1981 · S/N E-1902N81HCSmith Ronald Shane · Peachtree City, GABuilt 1990 · S/N TH-1600N81RJHughes Frank H · Hackberry, LABuilt 1979 · S/N E-1617N81TBMalachi Leasing Co · Wilmington, DEBuilt 1978 · S/N TJ-147N81TEMichaud Nathan M · Willows, CABuilt 1980 · S/N TH-1195N81UCRegistration Pending · Orchard Park, NYRegistration pendingBuilt 1971 · S/N TH-142
Back to AD 87-18-06 R1