OpenAirDocs.org
AD 97-25-02

Registered aircraft · 158

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-02')
    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-02')
  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.

N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100CFRed Rooster Rentals LLC · Alto, GABuilt 1972 · S/N 229N100KEPm Leasing Inc · Perris, CABuilt 1974 · S/N 313SAN100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SAN1164FRegistration Pending · Dickerson, MDRegistration pendingS/N 1562 S.A.N117HGobuyair LLC · Flint, MIBuilt 1979 · S/N 751SAN11SJSouthland Metroplex Aviation LLC · Colleyville, TXBuilt 1973 · S/N 285N122MAPanda Aviation Inc · Washougal, WAS/N 207N124PCSaxton Leasing Inc · Plymouth, MIS/N 438SAN129DWDelta Whiskey Ltd · Staten Island, NYBuilt 1974 · S/N 653N130MS3b Leasing LLC · Fairhope, ALS/N 750SAN13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694N143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324N145FSSolitaire LLC · Appleton, WIS/N 437 S.AN14VLJpw Aviation LLC · Clarksdale, MSBuilt 1981 · S/N 1514SAN15TCStax Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 692N15TRNorthwest Aviation LLC · Fargo, NDBuilt 1981 · S/N 446 S.A.N165MARegistered aircraftBuilt 1975 · S/N 326N1727SN1727s LLC · Calhoun, GAS/N 1504 S.A.N175CAAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1979 · S/N 736SAN178SBCrawford Setrige · Santa Barbara, CAS/N 435 S.A.N17HGMu2 LLC · Lewes, DEBuilt 1981 · S/N 1510 S.A.N18BFCenter For Endodontics Inc · Fresno, CABuilt 1969 · S/N 173N193AABig Mountain Aviation Inc · Whitefish, MTBuilt 1979 · S/N 741SAN196MAStef Air LLC · Muscle Shoals, ALBuilt 1979 · S/N 764 S.A.N200GCameron Global Strategies LLC · Springboro, OHBuilt 1981 · S/N 452 S.A.N2100TJ R Aero Leasing Inc · Lawrence, KSBuilt 1969 · S/N 182N216CDLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 323N219MAJa1 Aviation LLC · Sedan, KSBuilt 1981 · S/N 440 S.A.N220JSMt Mgt LLC · Missoula, MTBuilt 1981 · S/N 1545 S.A.N222FAExpress Aviation Management LLC · Dover, DES/N 714SAN228WPRegistration Pending · Wichita, KSRegistration pendingBuilt 1972 · S/N 228N22MZChurchill Robert Jr · Wasilla, AKS/N 158N24WCDach Capital Holdings Inc · Newark, DES/N 705SAN252BWMotor Vanguard LLC · Campbellsville, KYBuilt 1980 · S/N 423 S.A.N261WBNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1975 · S/N 330N271TWBaker Aviation LLC · Dover, DES/N 734 S.A.N272MCN272mc Leasing LLC · South Jordan, UTBuilt 1973 · S/N 272N281MAWife Approved LLC · Torrance, CABuilt 1973 · S/N 261N28AFEumundi Trading Co Inc · Wilmington, DES/N 241N2RRMelocity Air LLC · Saint Petersburg, FLBuilt 1981 · S/N 454 S.A.N305DSAircraft Operations LLC · Portland, ORBuilt 1975 · S/N 328N316ENFayetteville Aviation Inc · Fayetteville, TNBuilt 1976 · S/N 349SAN321GMWestern News & Info Inc · Prescott Valley, AZBuilt 1981 · S/N 1505 SAN324GMSycan Corp DBA · Paso Robles, CABuilt 1974 · S/N 310N325MASouthern Aviation LLC · Durham, NCBuilt 1974 · S/N 325N32ECAlan H Brodine Dmd Pc · Rochester, NYBuilt 1977 · S/N 699SAN338MLJdm Aviation LLC · Marceline, MOBuilt 1981 · S/N 1539SAN33EWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1981 · S/N 1519 S.A.N350RGAdams Michael D · Mckinney, TXBuilt 1980 · S/N 773 S.A.
Back to AD 97-25-02