AD 97-01-05

Registered aircraft · 613

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-01-05')
    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-01-05')
  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.

N252RVHssj LLC · Chattanooga, TNBuilt 1998 · S/N 5250252N253CWRegistered aircraftBuilt 1998 · S/N 525-0253N256DVRdv Aviation LLC · Grand Rapids, MIBuilt 2011 · S/N 525C0049N256JBBlossman Gas Of North Carolina Inc · Swannanoa, NCBuilt 1998 · S/N 525-0284N257DVRdv Aviation LLC · Grand Rapids, MIBuilt 2011 · S/N 525C0052N25BGSpearfish LLC · St Peters, MOBuilt 2000 · S/N 525-0363N25LZTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2003 · S/N 525A0177N25PJPjs Aviation LLC · Dunn, NCBuilt 2006 · S/N 525-0607N260AMQualitair LLC Trustee · MichelstadtBuilt 1998 · S/N 525-0260N262BKOmicron Business Services Inc · Winter Park, FLBuilt 1998 · S/N 525-0262N263FBCrye-Leike South Inc · Memphis, TNBuilt 1998 · S/N 525-0263N26AUnlimited Boat Sales Inc · Page, AZBuilt 1999 · S/N 525-0325N26RLJs Aircraft LLC · Eden, NCBuilt 1997 · S/N 525-0207N273RJDylans Rv Center LLC · Waterford Works, NJBuilt 2003 · S/N 525A0160N278KThienes Engineering Inc · La Mirada, CABuilt 2003 · S/N 525-0527N27CJ411kc LLC · Tuscaloosa, ALBuilt 1999 · S/N 525-0311N281PRScaled Composites LLC · Mojave, CABuilt 1998 · S/N 001N288G4m Aviation LLC · Fort Worth, TXBuilt 2001 · S/N 525A-0035N28CKC Star Aviation LLC · Evansville, INBuilt 1997 · S/N 525-0210N28QAHuff Air LLC · Uvalde, TXBuilt 1997 · S/N 5250215N28RKRd Aviation Lp · Redlands, CABuilt 1995 · S/N 525-0111N294CWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 525-0114N295DS4f Managment LLC · Salem, ORBuilt 1994 · S/N 525-0091N29MWWrdc Enterprise I LLC · Ardmore, PABuilt 2019 · S/N 136N300BVCj Bravo Victor LLC · Ridgeland, MSBuilt 2001 · S/N 525-0418N300FCDresden Aviation LLC · Atlanta, GABuilt 1998 · S/N 525-0248N300HFMorgan Aviation Leasing LLC · Knoxville, TNBuilt 2011 · S/N 525B0363N303KMCoastal Rentals LLC · Allen, KYBuilt 2000 · S/N 525-0180N306CJRegistered aircraftBuilt 2001 · S/N 525A-0016N307MRSilverstar II LLC · Houston, TXBuilt 1977 · S/N 501-0012N30LAAerokb LLC · Wilmington, DEBuilt 1993 · S/N 5250041N30MSkysouth Aviation Inc · Durham, NCBuilt 2003 · S/N 525-0506N30VRWd Journeys Inc · Downers Grove, ILBuilt 2002 · S/N 5250481N310GTGt Carriers Aircraft LLC · Bakersfield, CABuilt 2002 · S/N 525A-0086N311SQJb&B Capital LLC · Knoxville, TNBuilt 2001 · S/N RB-5N313WLPeak Aviation LLC · Royal Oak, MIBuilt 2000 · S/N 525-0366N315HCHooper Holdings LLC · Madison, WIBuilt 2000 · S/N 525-0373N316PJWmj Aviation LLC · Wilmington, DEBuilt 2000 · S/N 525-0405N318CGSvp LLC · Missoula, MTBuilt 1999 · S/N 525-0323N319JDHollingsworth Intergalactic LLC · Clinton, TNBuilt 1997 · S/N 5250216N31CJ212 Investments Of Montana LLC · Collinsville, OKBuilt 2001 · S/N 525-0474N31HDHotel Delta LLC · Sacramento, CABuilt 1998 · S/N 525-0261N31WEWorldwide Equipment Of Tn Inc · Knoxville, TNBuilt 2000 · S/N 5250362N321RRambarran Brian D · Clarence Center, NYBuilt 1994 · S/N 525-0049N322SBHuff Air LLC · Uvalde, TXBuilt 2011 · S/N 525C0053N323ADShc Citation LLC · Jonesburg, MOBuilt 2002 · S/N 525A0124N323EZN323ez LLC · Amarillo, TXBuilt 1996 · S/N 525-0128N323SKMacd Capital LLC · Newark, DEBuilt 2002 · S/N 525A0134N325RCCharlie Bravo Leasing LLC · Chandler, AZBuilt 2005 · S/N 525B0021N326JKRiver Bank Aviation LLC · Dover, DEBuilt 2003 · S/N 525-0511
Back to AD 97-01-05