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.

N181CBBuchanan Clayton W · Fernandina Beach, FLBuilt 1970 · S/N D-9124N181JPRegistered aircraftS/N CE-965N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363N181PJPeake Herschel S · Dallas, TXBuilt 1976 · S/N D-9876N1820FHamilton Aviation LLC · Waycross, GABuilt 1981 · S/N E-1893N1820LSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-843N1822NMars Michael Morrow · Collierville, TNBuilt 1981 · S/N D-10377N1822WLawrence Kevin M · Meridian, MSBuilt 1973 · S/N D-9424N18246Radial-Air Leasing Inc · Caro, MIBuilt 1977 · S/N CE-720N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248N18253Glass Anthony A Trustee · Plano, TXBuilt 1977 · S/N E-1067N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877N1825SEngebretson Christopher D · Greenville, INS/N E-1898N18265Strance Gordon M · Sevierville, TNBuilt 1987 · S/N E-2381N1826LRhr Management Inc · Bancroft, WIBuilt 1976 · S/N E-845N1826VBig Blue Sky Aero LLC · Austin, TXBuilt 1997 · S/N E-3086N18271Ramsey Richard K · Houston, TXBuilt 1977 · S/N E-1068N18275Strong Tower Worship Center LLC · Delhi, LAS/N E-1071N18276Stack Ed · Prospect Heights, ILS/N D-10031N1827LCone James R Jr · Lubbock, TXS/N TH-741N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N18284Condor Aviation LLC · Bethlehem, PABuilt 1977 · S/N E-1073N18287Three Wings Aviation LLC · Kalispell, MTBuilt 1977 · S/N D-10032N18290Koelbel Scott W · Spring, TXBuilt 1977 · S/N E-1076N18291Meoli Christopher J · Rancho Mirage, CABuilt 1977 · S/N CE-724N18294Bundy Holdings LLC · Walnut Grove, MOBuilt 1977 · S/N D-10034N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282N1829WRight Wing LLC · Newnan, GABuilt 1973 · S/N E-387N18302Allison Aircraft Sales LLC · Avon, CTBuilt 1977 · S/N E-1081N18304Bean David Jay · Miami, TXBuilt 1977 · S/N D-10037N18307Wings Management LLC · Springville, UTBuilt 1977 · S/N D-10038N18308Jlmc Blackland LLC · Marietta, GABuilt 1977 · S/N E-1083N1830FKing Barry J · Bentonville, ARBuilt 1981 · S/N E-1905N1830MDcf30 Corp · Doral, FLS/N E575N1830SN1830s Aviation LLC · Gainesville, GABuilt 1981 · S/N E-1906N1830VStress Aircraft Holdings LLC · Pilot Mountain, NCBuilt 1997 · S/N E-3087N1830WSoyars Tom · San Marcos, TXBuilt 1973 · S/N D-9428N1830ZJaju Aviation Inc · Abilene, TXBuilt 1981 · S/N TJ-379N18315Gregory G William Jr · York, SCBuilt 1977 · S/N D-10039N18318Registration Pending · Fosters, ALRegistration pendingBuilt 1977 · S/N D-10041N1831DBeliveau E Charles · West Newbury, MABuilt 1981 · S/N E-1907N18320Cox Jack H Jr · Arlington, TXBuilt 1977 · S/N TH-849N18321Bravo Delta Aviation LLC · Sand Springs, OKBuilt 1977 · S/N CE-727N18326Vanmeter Paul · Sunnyvale, TXBuilt 1977 · S/N E-1094N18327Franco Nello · Burlingame, CABuilt 1978 · S/N E-1286N18329Coggin Marilyn · Longview, TXBuilt 1977 · S/N D-10044N1832BR&S Acquisitions LLC · Weatherford, TXBuilt 1981 · S/N E-1908N1832SColwell Anthony R · Houston, TXBuilt 1981 · S/N CE-969N1832WTailwinds Aviation LLC · Beechgrove, TNBuilt 1972 · S/N TE-882
Back to AD 87-18-06 R1