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.

N40CJInco Investments LLC · San Jose, CABuilt 2004 · S/N 525-0540N40JDNup Aviation LLC · Princeton, ILS/N RB-35N411VRAirtrust LLC -10-Series 10 Trustee · Sheridan, WYBuilt 2001 · S/N 525-0411N413ALPlumbfly Aviation LLC · Granbury, TXBuilt 2005 · S/N 525B0054N414FWIron Steel And Dirt LLC · Fort Wayne, INBuilt 2002 · S/N 525A0081N414TELaz Air LLC · Hartford, CTBuilt 2001 · S/N RB-4N417CWing And A Prayer Inc · Walnut Creek, CABuilt 2010 · S/N 525C0021N417FCGreenway Pc-24 LLC · Orlando, FLBuilt 2019 · S/N 137N417QC P Holdings LLC · Watertown, SDBuilt 2000 · S/N 525-0385N418KCHastings Steve · Corpus Christi, TXBuilt 1996 · S/N 525-0130N420CROrange Lightning LLC · Piqua, OHBuilt 2004 · S/N 525A0215N420EHGk Racing LLC · Derwood, MDBuilt 2001 · S/N 525A0027N425WHTransportation Services LLC · Huntsville, ALBuilt 2004 · S/N 525-0537N426EDWindsock Aviation LLC · Bridgeport, WVBuilt 2001 · S/N 525-0426N428MGSav Aviation LLC · Jacksonville, TXBuilt 2001 · S/N 525-0457N429MRSmooth Air Leasing LLC · Dubuque, IABuilt 2010 · S/N 525C0011N430BTDry Valley Investors LLC · Cleveland, TNBuilt 2001 · S/N 5250451N430JFAusome Aviation LLC · Atlanta, GABuilt 2004 · S/N 525-0530N432LWBell Avenue Aviation LLC · Des Moines, IABuilt 2004 · S/N 525B0003N43NWAirvest Partners LLC · New Bern, NCBuilt 2004 · S/N 525-0543N440BVBig Sky 205 LLC · Benbrook, TXBuilt 1997 · S/N 5250199N443BCTothemoon LLC · Salt Lake City, UTBuilt 1997 · S/N 525-0189N444CUBtga LLC · Brent, ALBuilt 2010 · S/N 525C0008N44CKMile High Carpet Rides LLC · Dover, DEBuilt 2000 · S/N 525-0401N44FJAurora Aircraft LLC · Waterford, MIBuilt 2012 · S/N 525C-0071N44VSHornet Aviation LLC · Anaheim, CABuilt 2002 · S/N 525-0500N450CMJonda LLC · Sioux Falls, SDBuilt 2011 · S/N 525C0022N450TRBc Leasing LLC · Chesterfield, MOBuilt 2005 · S/N 525A0227N454MAMarv Air LLC · Chattanooga, TNBuilt 1998 · S/N 525-0286N45AFCenturion Air LLC · Draper, UTBuilt 1978 · S/N 5010284N469RBDavisair Inc · Lynchburg, VABuilt 2001 · S/N 525A0031N46BEOverordered LLC · Jacksonville Beach, FLBuilt 2002 · S/N 525A-0116N471MDCitation Management LLC · Pelham, ALBuilt 1995 · S/N 525-0122N473DBTrans Air LLC · Helena, MTBuilt 1996 · S/N 525-0129N475DHDesign Homes Inc · Prairie Du Chien, WIBuilt 2002 · S/N 525A0090N479CJLima Alpha One LLC · Newark, DEBuilt 2005 · S/N 525-0556N479MYMcclain Mcclain Mcclain Inc · Ridgeland, MSBuilt 1993 · S/N 525-0018N47SHGc Aviation Investments LLC · Augusta, ARBuilt 1993 · S/N 525-0017N481AMRavencrest LLC · Foxboro, MABuilt 2011 · S/N 525C0029N484JSouthern Airways LLC · Ridgeland, MSBuilt 1994 · S/N 525-0048N486CCFlint Transport LLC · Albany, GABuilt 1997 · S/N 525-0213N487TTThompson Tractor Co Inc · Birmingham, ALBuilt 2005 · S/N 525B0022N488SRHard Way LLC · Dover, DEBuilt 2002 · S/N 525-0488N489CBAir Giant LLC · Watsonville, CABuilt 2002 · S/N 525-0489N489HCJ C Cheek Contractors Inc · Kosciusko, MSFirst renewal noticeBuilt 2001 · S/N 525-0437N48DRRonald L Anderson LLC · Amery, WIBuilt 1998 · S/N 525-0272N48KFFelder William D · Dallas, TXBuilt 2012 · S/N 525C0079N490RMDd Sparkplug LLC · Ashtabula, OHBuilt 2005 · S/N 525A0300N4976HSky Blue Aviation Sales LLC · Bessemer, ALBuilt 2002 · S/N 525A0130N500SDLord Derby Air LLC · Yukon, OKBuilt 2002 · S/N 525A0132
Back to AD 97-01-05