OpenAirDocs.org
AD 93-24-02 R1

Registered aircraft · 806

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:93-24-02-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:93-24-02-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.

N9215YAstro Star Aviation Inc · Niles, MIBuilt 1968 · S/N 31-279N9218YHubble Boeing Development Corp · Gallipolis, OHBuilt 1968 · S/N 31-282N9224YFavret Bernard A · Ocean Springs, MSBuilt 1983 · S/N 31P-8414012N9225YDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 31P-8414015N9231YBbees LLC · Moss Point, MSBuilt 1983 · S/N 31P-8414017N9235YKamasano LLC · Highland, CABuilt 1983 · S/N 31P-8414020N9237YIal Corp · Lewes, DES/N 31P-8414022N9239YDelgado John F · San Antonio, TXBuilt 1984 · S/N 31P-8414040N9244YParker Aircraft Sales Inc · Wilmington, DEBuilt 1983 · S/N 31P-8414014N9245YMiles Aviation LLC · Sheridan, WYBuilt 1983 · S/N 31P-8414025N9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 31-8152160N9262YTwin Star Montana LLC · Kalispell, MTBuilt 1984 · S/N 31P-8414033N9266YTiffin Aire Inc · Tiffin, OHS/N 31T-1104008N926HBAwmr LLC · Conroe, TXBuilt 1975 · S/N 317552007N9272YIal Corp · Lewes, DEBuilt 1984 · S/N 31P-8414039N92BLIsland Birds Inc · St Thomas, VIS/N 31-7852095N931SAMarc Inc · Bolton, MSBuilt 1975 · S/N 317552036N937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeBuilt 1977 · S/N 31T-7720037N938PMD & B Aviation LLC · Stroudsburg, PABuilt 1983 · S/N 31-8452013N93SHBasin Air LLC · Mattawa, WAFirst renewal noticeS/N 31T-7904029N942EAngry Manx LLC · Riverside, CABuilt 1975 · S/N 31-7552116N944GMSix States Rentals Inc · Union, MOBuilt 1978 · S/N 31T-7904005N948MTTrasko Mark S · Boulder, COBuilt 1975 · S/N 31P-7530028N949WAP S S Air Inc · Middlesboro, KYBuilt 1976 · S/N 31-7612069N94JMRegistration Pending · College Station, TXRegistration pendingS/N 31P-47N950CTJack Of Queens LLC · Afton, OKBuilt 1977 · S/N 31T-7720069N950SACrop Dusters LLC · Maurice, IABuilt 1981 · S/N 31T-8166028N95KAAirborne Resources Inc · Midlothian, TXBuilt 1981 · S/N 318152146N95TCMmec Air LLC · Oxford, MSBuilt 1983 · S/N 31-8352037N961PAThiel Bros Roofing Inc · Sidney, MTFirst renewal noticeBuilt 1975 · S/N 317652017N96342Aircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 31-7405205N9680TK And K Recycling Inc · Fairbanks, AKBuilt 1970 · S/N 31689N96MAGoldielochs Air LLC · Annapolis, MDS/N 31T-7804005N970PSKrech Greg Trustee · Huron, SDBuilt 1979 · S/N 31T-8020023N974CSMcgregor Daniel A · Denali Natl Park, AKBuilt 1976 · S/N 31-7652120N977GUS Nameplate Co · Mount Vernon, IABuilt 1981 · S/N 31T-8104065N979SPGulf South Services LLC · Chipley, FLS/N 31-7812015N97MADodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7552006N980CATlh Enterprises Inc · Corsicana, TXBuilt 1980 · S/N 31T-8104010N982KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 31T-7820011N98FAHigher Purpose Aviaiton LLC · Spring Lake, MIBuilt 1980 · S/N 31T-8004028N98TGBell Scott W · Greeley, COS/N 31T-7904027N9901Noiw Resources LLC · Belle Chasse, LABuilt 1981 · S/N 318152168N990LRDavis Aviation Inc · Brandon, MSBuilt 1978 · S/N 31T7820060N993HRObxpress LLC · Frisco, NCBuilt 1978 · S/N 31-7812105N9942GQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 31-7712088N995AKLake Clark Air Inc · Port Alsworth, AKBuilt 1977 · S/N 31-7752089N998LMArmstrong Airlines Inc · Dover, DEBuilt 1980 · S/N 31T-8120006N9993RCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-8052029N999GKTaylor Craig E · Nantucket, MABuilt 1981 · S/N 31-8152101
Back to AD 93-24-02 R1