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.

N328CJRegistration Pending · College Grove, TNRegistration pendingBuilt 1999 · S/N 525-0328N330WSValiair Limited Co Trustee · Casper, WYBuilt 2006 · S/N 525B0066N331GGGed Jet LLC · Boca Raton, FLBuilt 1999 · S/N 525-0353N333BDFour Rings Aviation II LLC DBA · Gainesville, TXBuilt 2005 · S/N 525A0237N335JJFlybiz LLC · Zeeland, MIBuilt 2003 · S/N 525A0162N339HPAlpine Turbine LLC · Rollins, MTBuilt 1979 · S/N 501-0292N33BWMecum Auction Inc · Walworth, WIS/N 525A0010N33DTN33dt LLC · Phoenix, AZBuilt 1995 · S/N 525-0080N33FWNext Level Aviation Group LLC · Sarasota, FLBuilt 1997 · S/N 525-0203N33NMBighorn Airways Inc · Sheridan, WYBuilt 1993 · S/N 5250025N341ARMla Management LLC · Salt Lake City, UTBuilt 1999 · S/N 525-0341N345CJBrantigan Research LLC · Kalispell, MTBuilt 2002 · S/N 525A0136N347BCRoni 1 LLC · Sacramento, CABuilt 2001 · S/N 525-0431N34RLKar2 Inc · Sevierville, TNBuilt 2017 · S/N 525-0948N34TCHuff Air LLC · Uvalde, TXBuilt 1994 · S/N 5250083N350BVDiane S Lake-Ca LLC · Bakersfield, CABuilt 2003 · S/N 525A0186N351BCInternational Bank Of Commerce · Laredo, TXBuilt 1996 · S/N 525-0159N354RBD&J Air LLC · Canyon, TXBuilt 2002 · S/N RB-54N357BVHilltop Aviation Services LLC · Summit, NJBuilt 2011 · S/N 525C0060N358HAElsy Equipment LLC · Owasso, OKBuilt 1999 · S/N 525-0358N35CTBoulder Charters LLC · Billings, MTBuilt 2002 · S/N 525A-0120N35HCCorporate Air Service Inc · North Salt Lake, UTBuilt 2011 · S/N 525C0066N360PKWright Brothers Aviation LLC · Idaho Falls, IDBuilt 2011 · S/N 525C0030N360SHRkjm LLC · Superior, NEBuilt 1997 · S/N 525-0201N361TLCj3@0061 LLC · Saint Johns, MIBuilt 2006 · S/N 525B0061N364PKSky Hawk LLC · Moody, ALBuilt 1999 · S/N 525-0320N365SNNice Neighbors LLC · Wilmington, NCBuilt 1996 · S/N 525-0121N36RGJrb Of Montana LLC · Wooster, OHBuilt 1996 · S/N 525-0139N36TXFrog Air LLC · Amarillo, TXBuilt 1996 · S/N 525-0153N373AFSe Aero II LLC · Atoka, OKBuilt 1999 · S/N 525-0308N374QAWilmington Trust Company Trustee · Wilmington, DEBuilt 2022 · S/N 525C0374N377MAMadison Aviation LLC · Flowood, MSBuilt 2011 · S/N 525C0037N383BPMarshall Engines Inc · Kearney, NEBuilt 2005 · S/N 525B0042N388KTCj Leasing LLC · Moody, ALBuilt 2003 · S/N 525A0172N38QA7 Seas Aviation LLC · Monroe, GABuilt 2004 · S/N 525A0214N38RLAtg112 LLC · Reno, NVBuilt 2001 · S/N 525-0420N390SMRk Aero LLC · Sioux Falls, SDBuilt 2002 · S/N RB-36N391YSInfineon Aviation II LLC · Dallas, TXBuilt 2001 · S/N RB-6N392RGWhitt Aviation LLC · Lannon, WIBuilt 1999 · S/N 525-0340N392SMHarrison Aviation LLC · Yuma, AZBuilt 2000 · S/N 525-0392N399G399g LLC · Moody, ALS/N 525-0183N39CJBagwell Aviation LLC · Raleigh, NCBuilt 1993 · S/N 525-0039N3CTInncal LLC · Stockton, CABuilt 2005 · S/N 525B0041N3LDLucky Duck Enterprises LLC · El Paso, TXBuilt 2011 · S/N 525C0063N3SWAero Burro LLC · San Antonio, TXBuilt 2002 · S/N 525-0501N400ETSet Air LLC · Rocky Mount, NCBuilt 2012 · S/N 525C0077N400HTDonald D Godwin LLC · Conway, SCBuilt 2004 · S/N 525A0208N400STDuralake LLC · Corcoran, MNBuilt 2010 · S/N 525C0014N400WDPacific Coast Aviation Inc · Brookings, ORBuilt 2000 · S/N 525A0002N405VJVj24 Assets LLC · Lititz, PABuilt 2019 · S/N 125
Back to AD 97-01-05