AD 97-25-01

Registered aircraft · 3,184

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

N135RWOneal Eric T · Geneva, FLBuilt 1981 · S/N TJ-351N135SSTextron Aviation Inc · Wichita, KSS/N FM-135N136KFFisher Auto Parts Inc · Staunton, VABuilt 2016 · S/N FL-1036N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662N137FLCharlie-001 LLC · Sugar Grove, ILBuilt 1996 · S/N FL137N138MMTextron Aviation Inc · Wichita, KSS/N FM-138N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590N13PECamm Air · Spencer, IAS/N TJ-50N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753N140MCPlane To Sea LLC · Raleigh, NCBuilt 1996 · S/N FL-140N140MNTextron Aviation Inc · Wichita, KSS/N FM-140N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22N141LVictor One Four One LLC · Boston, MABuilt 2007 · S/N FL-524N141SMInfinity Aeronautics LLC · Greer, SCBuilt 1984 · S/N FA-23N141SULynch Family Companies Inc · Waucoma, IABuilt 2022 · S/N FL-1308N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042N142MNTextron Aviation Inc · Wichita, KSS/N FM-142N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612N143NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N FM-103N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49N1459General Atomics Aeronautical Systems Inc · San Diego, CABuilt 2009 · S/N FL-667N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476N148AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N FM-12N149CCCianbro Corp · Baltimore, MDS/N FA-145N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214N14VDouble D International LLC · Miami, FLS/N LJ-411N14VPAmerican Woodcraft LLC · Fort Denaud, FLBuilt 1981 · S/N P-576N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531N150GXWest Penn Aviation LLC · Midland, TXBuilt 2008 · S/N FL592N150RFR & F Wings III LLC · Liverpool, NYBuilt 2015 · S/N FL-1023N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50
Back to AD 97-25-01