OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,620

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-21-21-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:98-21-21-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.

N235EMcfarland Joel Cable · East Earl, PABuilt 1963 · S/N D-7162N235EDBeggs Kevin Robert · Lincolnton, GABuilt 1963 · S/N 28-10097N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443N235FPoirot Steven James · Anchorage, AKBuilt 1967 · S/N 28-10875N235FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2841285N235HBabin Richard T · Arnold, MDBuilt 1973 · S/N 28-7310176N235HLBeach Norman G Jr · Newman, CABuilt 1978 · S/N 18266526N235JKDetert Bradley · Valparaiso, INBuilt 1963 · S/N 27-587N235JTWings And Prop LLC · Montgomery, TXBuilt 1963 · S/N 28-10080N235LWWatkins James R · Granbury, TXBuilt 1964 · S/N 28-10536N235MAMorgantown Aero Corporation · Elverson, PABuilt 1967 · S/N 28-10867N235MHCharlie Papa LLC · Las Vegas, NVS/N 28-10553N235MLMcwhorter Richard T · Pearland, TXBuilt 1968 · S/N 28-11121N235PAGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 28-7816678N235PCBarefoot Aviation Management Inc · Fort Lauderdale, FLBuilt 1975 · S/N 28-7510049N235PFInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 28-7410083N235PJBoulos David S · Milford, CTS/N 28-7210023N235RRegistered aircraftBuilt 1966 · S/N D-8360N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446N235RGBispo Stuart · Seaside, CABuilt 1963 · S/N 28-10110N235SLifetime Aviation LLC · Lewes, DEBuilt 1964 · S/N D-7326N235SBMeiwes Christopher P · Dimmitt, TXS/N 28-11233N235SEPlane Flt LLC · Broken Arrow, OKBuilt 1981 · S/N E-1953N235SGZonaair LLC · Roll, AZS/N E-3544N235SMTriniair LLC · Warner Robins, GAS/N TH-926N235SRDraco Flight School DBA · Chino, CABuilt 2003 · S/N 2842182N235TLYoung Curtis A · Mcdonough, GAS/N 28-10769N235TPSvl Aviation LLC · Delray Beach, FLBuilt 1985 · S/N 28-8516036N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206N235WGCaughron Willie · Pylesville, MDBuilt 1966 · S/N 28-10742N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797N235WSGarza Johnny R · Visalia, CABuilt 1963 · S/N 28-10156N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088N23608Beech36 LLC · Clarkston, MIBuilt 1978 · S/N E-1188N23609Wiebelhaus John J · Strasburg, COBuilt 1978 · S/N D-10089N2360CCkt Aviation LLC · Anchorage, AKBuilt 1953 · S/N 30660N2360GVath Edward V · Acton, CABuilt 1958 · S/N 51660N2360JReed Matthew A · Burnsville, MNBuilt 1963 · S/N CD-698N2360RLamarra Anthony A · Clarkston, MIBuilt 1969 · S/N 28-5496N23612Lcms Limited · Durham, NCBuilt 1977 · S/N CE-756N23614Great American Jet Inc · Cincinnati, OHBuilt 1978 · S/N TC-2153N23615Yoder Metal & Post Frame & Building Supplies · Haven, KSBuilt 1977 · S/N E-1191N2361GMcmanigle Jeffrey M · Osakis, MNBuilt 1958 · S/N 51661N2361QLong Lawrence R · South Whitley, INS/N 28-7716100N2361RVenture West LLC · Mesa, AZBuilt 1969 · S/N 28-5497N23620Erickson Brian C · Pahrump, NVBuilt 1977 · S/N E-1165N23621Excellance Inc · Madison, ALBuilt 1977 · S/N E-1192N2362RBarone Christian · Stratham, NHBuilt 1964 · S/N 18255462N2362XFort Scott Family Medicine Pa · Fort Scott, KSBuilt 1965 · S/N 18256262N23639Teleprint Inc · Rydal, PABuilt 1978 · S/N E-1293
Back to AD 98-21-21 R1