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.

N901CSMarco Steven S · Atlanta, GABuilt 1990 · S/N CE-1477N901DCExcel Tree Care LLC · Alpharetta, GAS/N EA-208N901FJN901fj LLC · Miami, FLBuilt 1974 · S/N D-9657N901TCBoho LLC · Lewes, DEBuilt 1993 · S/N CE-1737N9020VCartwright David F · Menomonee Falls, WIBuilt 1969 · S/N TE-768N9021V9021 LLC · Sheridan, WYS/N TH-233N9022QHeading 360 LLC · Safford, AZBuilt 1970 · S/N CE-309N9022VBlu Dog Aviation LLC · Greenwich, NYBuilt 1971 · S/N E-276N9023QRegistered aircraftBuilt 1970 · S/N TH-68N9024VMinick Allen R · Beatrice, NEBuilt 1971 · S/N TE-837N902ATAbet · Freeport, MEBuilt 1991 · S/N E2623N902DRBaron Dreams LLC · Inlet Beach, FLS/N TH-1825N9033FMarshall Randy M · Dallas, TXBuilt 1990 · S/N CE-1456N9033QDavid E Weissman · San Diego, CABuilt 1970 · S/N D-9208N9034VVanderhoof Consulting LLC · Omaha, NEBuilt 1972 · S/N E-368N9035QBrown Vintage Airlines LLC · Mansfield, OHBuilt 1970 · S/N CE-310N9036VRobbins Ethan · North Grafton, MABuilt 1970 · S/N E-233N9039VCarper Paul · Conroe, TXBuilt 1973 · S/N E-391N903ATEga Three LLC · Gadsden, TNBuilt 1991 · S/N E2627N903VCrawford Carlos G · Osprey, FLBuilt 1974 · S/N E-562N9041CAlexander Stephen L · Sugar Land, TXBuilt 1977 · S/N D-10096N9041VSera Adam J · New Market, MDS/N CE-429N9042W42w LLC · Jackson, MOBuilt 1974 · S/N E-605N9044VThomas Richard D · Orange City, FLBuilt 1972 · S/N TH-216N9045QJohnson Steven F · Ennis, TXBuilt 1970 · S/N E-231N9048QNogle And Black Aviation Inc · Champaign, ILBuilt 1970 · S/N D-9189N904ADNorth South Aviation LLC · Belgrade Lakes, MEBuilt 1974 · S/N E-624N904ATBeitler Jonathan J · Camden, MEBuilt 1991 · S/N E2629N9053QOrville Ventures LLC · Leawood, KSBuilt 1970 · S/N D-9196N9056SKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N E-1301N9058QHeffley Lynn · Pottsboro, TXBuilt 1970 · S/N TH-95N905AAGraber Joel C · Collins, MSS/N TK65N905ATWagner Kendall · Yorba Linda, CABuilt 1991 · S/N E2632N905VPratt Raymond P · Sandia Park, NMBuilt 1974 · S/N D-9635N90659Jones Thomas J · Casper, WYBuilt 1973 · S/N D9437N9066SPower Flow Systems Inc · Daytona Beach, FLBuilt 1978 · S/N E-1305N9067QBrabeck Mark F · Glasgow, MTBuilt 1970 · S/N D-9200N9068QPursell Robert W · Las Vegas, NVBuilt 1970 · S/N D-9199N906VState Of Alabama · Montgomery, ALBuilt 1974 · S/N TE-983N9070SFontana Brent S · Rogers, ARBuilt 1978 · S/N CE-793N9072SSaddleback Enterprises LLC · Newport Beach, CABuilt 1978 · S/N E-1307N9074QDulin Michael N · Edmond, OKBuilt 1970 · S/N E-235N9075QBenson Edward A · San Antonio, TXBuilt 1970 · S/N D-9202N9076Q76q LLC · Ventura, CABuilt 1970 · S/N E-236N9081QReplogle Randall B · Gulfport, MSBuilt 1970 · S/N D-9203N9083SRobinson Charley C · Guthrie, OKBuilt 1978 · S/N TJ-152N9084QEanes Thomas M · Fort Worth, TXBuilt 1970 · S/N E-237N9086SKats Ventures LLC · Byron, MNBuilt 1978 · S/N CE-790N908ATWegener Airlines Inc · Ridgeland, MSBuilt 1991 · S/N E2639N908DBB36 LLC · Winter Park, FLBuilt 2002 · S/N EA-694
Back to AD 87-18-06 R1