OpenAirDocs.org
AD 98-24-14

Registered aircraft · 907

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:98-24-14')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-24-14')
  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.

N100CXCs Leasing LLC · Rockville, MDBuilt 1980 · S/N 414A0623N100HMSchultz David J · Neenah, WIBuilt 1978 · S/N 340A-0559N100JDMark Aviation LLC · Kingsport, TNBuilt 1981 · S/N 414A0669N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957N102WCDac 2020 Inc · Skaneateles, NYBuilt 1978 · S/N 340A0443N103JGRam Aero Development Inc · Waco, TXBuilt 1979 · S/N 414A0264N107FTRoyce Aviation LLC · Greenville, MSS/N 340A0909N108LVVandermolen Louis A Md · Laguna Beach, CAS/N 414A0841N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072N1141XChancellor Aviation LLC · Billings, MTBuilt 1978 · S/N 414A0215N114MHVlavic Aviation LLC · Hallandale Beach, FLBuilt 1979 · S/N 414A0458N115BHBighorn Airways Inc · Sheridan, WYBuilt 1982 · S/N 340A1531N115EATso Aviation LLC · Conway, ARBuilt 1978 · S/N 340A0484N116PAJht Aircraft LLC · Wilmington, DEBuilt 1978 · S/N 414A0021N118BHBighorn Airways Inc · Sheridan, WYBuilt 1975 · S/N 340A0003N119SKKing Air 3au LLC · Wichita, KSS/N 414A0660N11BNAlpha 414a LLC · New Smyrna Beach, FLBuilt 1979 · S/N 414A0311N11JARegistration Pending · Denison, TXRegistration pendingBuilt 1977 · S/N 340A0292N120HAAstley Mark C · Wayne, NJBuilt 1977 · S/N 340A0295N121BDKorn Air LLC · Fort Lauderdale, FLS/N 414A0297N121CBClark Andrew R · Woodside, CABuilt 1976 · S/N 340A0087N1232KCorporate Air LLC · West Mifflin, PABuilt 1984 · S/N 340A1815N1238RLtx Consulting LLC · Austin, TXBuilt 1977 · S/N 340A-0272N123BARothschild Jonathan Trustee · Tucson, AZS/N 414A-0065N123TBTango Bravo LLC · Wilmington, DEBuilt 1979 · S/N 340A0795N123TDVinanam Aviation LLC · Cupertino, CABuilt 1977 · S/N 340A0307N12434Aviation S And S LLC · Miami, FLBuilt 1983 · S/N 414A1002N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201N128BRNautilus Aviation LLC · Yadkinville, NCBuilt 1979 · S/N 414A0231N128MCDawson Aircraft Inc · Clinton, ARBuilt 1984 · S/N 340A1808N12SBSilvano Sal · La Grange, KYBuilt 1979 · S/N 340A0911N130HLFair Winds Aviation LLC · Shreveport, LABuilt 1979 · S/N 414A0322N130RACarter Distribution Lc · Salt Lake City, UTBuilt 1976 · S/N 340A0040N133PCGilco Distributors · Santa Rosa, CABuilt 1976 · S/N 340A0093N134GGGibson Gordon S Trustee · Pacific Palisades, CABuilt 1981 · S/N 340A1202N1362CPaw Management Inc · Calimesa, CAS/N 340A0012N1379GTwo Golf Tango LLC · Albuquerque, NMBuilt 1976 · S/N 340A0078N1380GWalborn & Associates Inc · Mountain Home, IDBuilt 1976 · S/N 340A0079N1383GKuper Carl J II · Dalhart, TXBuilt 1976 · S/N 340A0082N13KGCarroll Jeffrey P · West Bloomfield, MIS/N 340A0215N140JRobert D Grace LLC · Amarillo, TXBuilt 1981 · S/N 414A0650N140KMKnight Edge LLC · Clearwater, FLBuilt 1981 · S/N 414A-0674N140TPHickox Joseph · Rollins, MTS/N 340A0235N144JCJackson Construction Aviation LLC · Quitman, TXBuilt 1977 · S/N 340A0360N149ARB-Cat Aviation LLC · Tulsa, OKBuilt 1983 · S/N 414A1006N150CFDesutter S Bryan · Manito, ILBuilt 1980 · S/N 340A1215
Back to AD 98-24-14