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.

N4194SKilpatrick Bryan J · Poway, CABuilt 1975 · S/N E-677N4197SIndependence Aviation Inc · Scottsdale, AZBuilt 1975 · S/N D-9762N41AZAlexander Peter · Palo Alto, CABuilt 1991 · S/N E-2628N41BHSmb Aero LLC · Grapevine, TXS/N CE-1695N41CFJet Movers LLC · Vandalia, ILS/N TJ-47N41CMClark Patrick L · Kenai, AKBuilt 1977 · S/N D-9967N41ECTreeline Helicopters Inc · Bristol, TNS/N TH-471N41EGSal Aviation Inc · Wilmington, DEBuilt 1978 · S/N TK-75N41FROplnet LLC · Arlington, VABuilt 1972 · S/N E-371N41HCDkh Air LLC · Shady Shores, TXBuilt 1974 · S/N E-592N41LLNotjets LLC · Paradise Valley, AZBuilt 1980 · S/N E-1644N41LM92 Aviation LLC · Whiteville, NCS/N TH-967N41NHHartz Norman E · Gardnerville, NVBuilt 1997 · S/N E-3139N41SKSkylane 47n LLC · Seattle, WABuilt 1984 · S/N E-2142N41VHSutherland Jason · Auburn, WABuilt 1993 · S/N E-2832N41VKGalaxy Aviation LLC · Nantucket, MABuilt 1981 · S/N E-1885N4203ABas Part Sales LLC · Greeley, COBuilt 1970 · S/N TH-22N4203SWright John D · Richmond, TXBuilt 1976 · S/N E-958N420BWGordo Air Inc · Middletown, DENon-citizen corporation, flight hours not reportedS/N EA-636N420JFlying Mules LLC · Hutchinson, KSBuilt 1979 · S/N CE-894N420ZBAdaptive Aerospace Corp · Tehachapi, CAFirst renewal noticeBuilt 1980 · S/N E-1765N4212SColburn Reno Bryan · Turner, MTBuilt 1976 · S/N D-9954N4215SHolliday Bryan E · Flower Mound, TXBuilt 1976 · S/N CE-678N4217SAnla Aviation LLC · Bentonville, ARBuilt 1977 · S/N D-9968N421PWMead Lawrence C Trustee · Powell, OHBuilt 2002 · S/N E-3466N422ATDec Flight Services LLC · Sandy Springs, GABuilt 2000 · S/N E-3333N422DBHarron Eric J · Austin, TXBuilt 1978 · S/N E-1386N422MMBolt Robert S · Tampa, FLBuilt 1998 · S/N E-3217N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658N423CLTmt Aero Inc · Perrysburg, OHBuilt 1983 · S/N TH1394N423JKKraft John · Lake View, IABuilt 1982 · S/N E1951N423PPrestige Worldwyde! LLC · Concord Township, OHBuilt 2002 · S/N E 3439N4245AMac Flight LLC · Conway, ARBuilt 1970 · S/N D-9126N424JBJsj Aircraft Holdings LLC · San Diego, CAS/N CE-1363N424QLj Sutter Aviation LLC · Shavertown, PABuilt 1990 · S/N TH-1582N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35N4257ST&S Proch Investments LLC · Harrisonville, MOBuilt 1976 · S/N E-939N425PQuimus Aviation LLC · Townsend, WIBuilt 1998 · S/N E-3175N4260SMueller Phillip Robert · Newbury Park, CABuilt 1977 · S/N E-959N4262SPeck Crosby S · Meredith, NHS/N E-942N4266SFowler Thomas J · Keller, TXBuilt 1977 · S/N TE-1086N426DDRare Air Aviation Services LLC · Santa Rosa, CABuilt 1970 · S/N TH-93N4271SVk Aviation LLC · Jennings, LABuilt 1976 · S/N E-944N4272SSchechter Stuart · Great Neck, NYBuilt 1976 · S/N D-9959N4275SEvergreen Aviation LLC · Franktown, COBuilt 1977 · S/N D-9961N4279SSteinbacher Deane E · Waterford, WIBuilt 1976 · S/N E-948N427BBBolder Travel LLC · Superior, COS/N E-2984N427BDNostra Aeris LLC · Gassville, ARBuilt 1991 · S/N EA528N427CWRural Orthopedic Care LLC · Ardmore, OKBuilt 2001 · S/N E-3400N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113
Back to AD 87-18-06 R1