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.

N490MLegacy Ofs Construction LLC · Stillwater, OKBuilt 1983 · S/N EA-390N491BAirside Kc LLC · Riverside, MOBuilt 1974 · S/N TE-1012N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491N493DVSatterfield Thomas J · Ewing, ILBuilt 1979 · S/N TJ-218N493KPCatalano Gerry · Shingle Springs, CABuilt 1988 · S/N CE-1231N493WLarreategui Patrick A · Dayton, OHBuilt 2003 · S/N E-3493N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N494PGarrett Jacob Y · West Plains, MOBuilt 1993 · S/N CE-1738N4956MMurray Timothy · Orlando, FLBuilt 1978 · S/N CE-781N495GCCunningham John · Naperville, ILBuilt 1981 · S/N E-1876N4970MAerotrust Services Corp · Wilmington, DEBuilt 1978 · S/N E-1277N4972MZenith Air LLC · Salome, AZBuilt 1978 · S/N E-1275N4979MLager Eric Willard · Palos Park, ILBuilt 1978 · S/N E-1281N497DTPond Fred C · Van Wert, OHS/N E-3569N497EBFl Scapes Inc · Panama City Beach, FLBuilt 1999 · S/N E-3296N497LGulf Sierra Air Corp · Portola Valley, CABuilt 1984 · S/N E-2156N4984MBas Part Sales LLC · Greeley, COBuilt 1978 · S/N D-10137N4986MLaney Construction Co Inc · Murphy, NCBuilt 1978 · S/N E-1282N4989MRistevski Bill · Vacaville, CABuilt 1978 · S/N D-10140N498CPConstruction Design Management LLC · Bowling Green, KYS/N TH-703N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146N499DLCjrr Consulting LLC · Denver, COS/N EA-58N49DCenturian 94n LLC · Ripon, CABuilt 1974 · S/N TH-542N49HRBon-36 Ltd · Shavano Park, TXBuilt 1993 · S/N E-2790N49JGCavanaugh James Martin Jr · Ann Arbor, MIBuilt 1990 · S/N CE-1505N49JLPalmetto Aviation Solutions LLC · Woodruff, SCBuilt 1975 · S/N E-746N49LFHerrera Gilbert Jr Trustee · Arcadia, CABuilt 1979 · S/N E-1510N49PSZulu Time LLC · Norfork, ARBuilt 1978 · S/N E-1227N49SBGarcia Edward · Ooltewah, TNBuilt 1991 · S/N E-2661N49TRVincent T Remcho Phd LLC · Corvallis, ORBuilt 1974 · S/N D-9628N4EQUsi Leasing LLC · Garden City, KSBuilt 1984 · S/N E-2205N4FHWall Jacob · Grapevine, TXBuilt 1976 · S/N D-9973N4GAAircraft Owners And Pilots Association · Frederick, MDBuilt 1989 · S/N E-2466N4HESouth Florida Aerobatics LLC · West Palm Beach, FLBuilt 1976 · S/N TH-787N4HFBat Plane LLC · Memphis, TNS/N E-2421N4JADiamond Aviation LLC · Tuscaloosa, ALBuilt 1994 · S/N TH-1714N4JXCosta James J · Tulare, CABuilt 1974 · S/N D-9642N4KTEthriedge Jeffrey A · Elizabethtown, PAS/N CE1115N4LCCorbett Perry Howard III · Ferriday, LABuilt 1991 · S/N E-2617N4LWWilliams Jason Allen · Cypress, TXBuilt 1992 · S/N TH-1652N4MCCoberly Adrian R · Manhattan, KSBuilt 1984 · S/N TJ-461N4RBFlying Country Club Inc · Coal Valley, ILBuilt 1973 · S/N CE-469N4WZMulligan Peter · Richardson, TXBuilt 1970 · S/N TH117N4XPPazdziora Ronald G · St Charles, ILBuilt 1982 · S/N D-10401N5001XVirginia Brian · Maple Grove, MNBuilt 2002 · S/N E-3481N500BAKw Plastics · Troy, ALBuilt 1997 · S/N TH-1814N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418N500BQCoolbreeze LLC · Ripon, CAS/N EA-336N500CMM & M Aviation LLC · Portsmouth, NHBuilt 1979 · S/N E1505N500DMFive Delta Mike Inc · Wilmington, DEBuilt 1987 · S/N CE-1122
Back to AD 87-18-06 R1