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.

N17VBN17vb LLC · Nacogdoches, TXBuilt 1997 · S/N 525-0206N181CHNew Cj4 LLC · Bartlett, ILBuilt 2010 · S/N 525C0015N181CNContrails II Inc · Wilmington, DEBuilt 2011 · S/N 525C0040N183TXCrump Properties LLC · Jasper, ALS/N 525A0183N186TWTnp Aviation LLC · Valdosta, GABuilt 2001 · S/N 525-0416N187MCAe Aircraft LLC · Longview, TXBuilt 1998 · S/N 525-0276N189MSAviation II Inc · Tulsa, OKBuilt 2003 · S/N 525A0189N18TFAirflite Financial Company LLC · Alpena, MIBuilt 2001 · S/N 525A0014N193PPMarietta Silos LLC · Marietta, OHBuilt 2003 · S/N 525A0192N194MGSdw Aviation LLC · Albany, GABuilt 1999 · S/N 525-0357N195MFHat*Trick Holdings LLC · Buchanan, MIBuilt 1995 · S/N 525-0110N19DPMonterey Bay LLC · Atlanta, GABuilt 1993 · S/N 525-0040N19MFSky Solutions LLC · Detroit, MIBuilt 2001 · S/N RB-19N1BZL2 Operations LLC · Saint Paul, MNBuilt 2001 · S/N 525-0439N1EGLevenson Louis · Atlanta, GABuilt 2002 · S/N RB-43N1FMCokelet LLC · South Padre Island, TXBuilt 1997 · S/N 525-0218N1HRays Leasing LLC · Hobe Sound, FLBuilt 2005 · S/N 525B0055N1MWWilcox Jet Logistics LLC · Toledo, OHBuilt 2010 · S/N 525B0351N200SLAtfo LLC · Wildwood, MOBuilt 2001 · S/N 525-0461N201RCRcc Management & Aviation LLC · Magnolia, TXBuilt 2001 · S/N 525A0043N204JCentral Beach LLC · El Paso, TXBuilt 1996 · S/N 525-0164N205TCCarpenter Aviation LLC · Northport, ALBuilt 1994 · S/N 525-0050N205YYLittle H Holdings LLC · Piqua, OHBuilt 2004 · S/N 525A0205N207MMMmg Insurance Co · Presque Isle, MEBuilt 2002 · S/N 525A0084N20DCKar Aviation LLC · New Albany, MSS/N 5250208N20VLRusken Packaging Inc · Cullman, ALBuilt 1994 · S/N 525-0069N210MBSafe Flight LLC · Suwanee, GABuilt 1997 · S/N 525-0211N213JTLake Air Sale LLC · Wilmington, DEBuilt 2002 · S/N 525-0492N215RBGolden Eagle Aviation Lc · Orlando, FLBuilt 2005 · S/N 525A0243N219CMMt Aviation LLC · Cincinnati, OHBuilt 2001 · S/N 525A0045N219LEstrella Aviation III LLC · Phoenix, AZBuilt 2011 · S/N 525C0023N21RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 525A-0092N21TKMtk Leasing LLC · Woodburn, ORS/N 525-0131N21VCCitation Hawk LLC · Moody, ALBuilt 1995 · S/N 525-0106N21XPBroad Street Aviation LLC · Columbus, OHBuilt 2001 · S/N RB-9N220ARAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2005 · S/N 525B0029N220JLJuliet Charlie LLC · Wolf Creek, MTS/N 525-0020N222JMOld Well Aviation LLC · Charlotte, NCBuilt 1995 · S/N 525-0116N222NFShelter Air Charter LLC · Brooklyn, NYBuilt 2002 · S/N 525A-0074N223CFCbel Aviation Inc · Macon, GABuilt 2000 · S/N 525-0403N223JFJettair LLC · Dallas, TXBuilt 1997 · S/N 525-0223N224CJEagle Aviation LLC · Hamel, MNBuilt 1997 · S/N 525-0224N224WACook Childrens Health Enterprises · Fort Worth, TXBuilt 2018 · S/N 102N23BKBig Sky Leasing LLC · Madison, WIBuilt 1997 · S/N 525-0198N242BSDm Aviation LLC · Lexington, SCBuilt 1997 · S/N 525-0230N242RFOwsley Robert L · Anchorage, AKBuilt 1998 · S/N 525-0294N246GLBonanza Management LLC · Newark, DEBuilt 2001 · S/N 525-0446N249CALafayette Flight Service LLC · Broussard, LABuilt 1998 · S/N 525-0291N251KDBusiness Aviation LLC · Springfield, MOBuilt 2002 · S/N 525A0133N252JKLow Country 525 LLC · Charleston, SCBuilt 1996 · S/N 525-0166
Back to AD 97-01-05