OpenAirDocs.org
AD 2007-23-13

Registered aircraft · 597

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:2007-23-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-13')
  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.

N380CFBarkley Air LLC · Scottsboro, ALBuilt 1996 · S/N 560-0380N387AStatewide Transportation LLC · Oklahoma City, OKBuilt 1993 · S/N 560-0240N387GDDodson International Parts Inc · Rantoul, KSS/N 560-0705N387MMMesquite Aviation LLC · Lewes, DEBuilt 1991 · S/N 560-0109AN38MRCam Jet Aviation LLC · Lamesa, TXBuilt 1997 · S/N 560-0412N391JMMeisner Aircraft Inc · Janesville, WIBuilt 1996 · S/N 560-0391N3RBSx Transport LLC · Portland, ORBuilt 1989 · S/N 560-0035N400KSNbs Air LLC · Creve Coeur, MOBuilt 1990 · S/N 5600041N403ETFlymehlingav LLC · Tyler, TXBuilt 1999 · S/N 560-0535N404GCushing Stone Company Inc · Amsterdam, NYBuilt 1991 · S/N 560-0095N406EJLynch Flying Service Inc · Billings, MTS/N 560-0756N406RD406 Aviation LLC · Lake City, FLBuilt 1992 · S/N 560-0171N410DMJmp Aircraft Services LLC Trustee · Wasilla, AKBuilt 1992 · S/N 560-0184N416BABtt Air LLC · Wilmington, DEBuilt 1996 · S/N 560-0359N4200KVs Airco LLC · Humble, TXBuilt 1996 · S/N 560-0354N423HKGem Air LLC · Bakersfield, CABuilt 1993 · S/N 560-0245N42592Tpl Flight LLC · Fish Creek, WIBuilt 1996 · S/N 560-0361N427MCN427mc LLC · Bay City, MIBuilt 2008 · S/N 560-0787N430AMJems Air Inc · Glenwood, MDBuilt 2000 · S/N 560-0542N430TATeam Aero LLC · Olathe, KSS/N 560-0533N432TXStagg Air LLC · Midland, TXBuilt 1991 · S/N 560-0154N43NCCitation Encore LLC · Nashville, TNBuilt 2005 · S/N 560-0685N443EA500 Knot LLC · Granbury, TXBuilt 1996 · S/N 560-0400N444GGLipsitz Melvin Jr · Waco, TXBuilt 1994 · S/N 560-0262N444RFCascadian I LLC · Bellevue, WABuilt 2001 · S/N 560-0559N444ZHBma Leasing LLC · Greensboro, NCBuilt 1997 · S/N 560-0444N44GFCain Management LLC · Cropwell, ALBuilt 2008 · S/N 560-0791N44LVCessna 44 LLC · Indianapolis, INBuilt 1996 · S/N 560-0397N450MMDcbf LLC · Aledo, TXBuilt 1991 · S/N 560-0119N453JGShell Mountain Ranch LLC · Cranfills Gap, TXBuilt 1991 · S/N 560-0158N458DACitation N458da LLC · Houston, TXS/N 560-0458N458NCBartmann Management LLC · Weatherford, OKBuilt 1998 · S/N 560-0478N459MBSt Pete Flight LLC · Saint Petersburg, FLS/N 5600438N45RCClassic Ag Aviation LLC · Kingston, OKBuilt 1990 · S/N 560-0071AN462BJd Russell Co · Tucson, AZBuilt 1989 · S/N 560-0016N469DNAerosam Equipment LLC · Beaver, PABuilt 1998 · S/N 560-0469N469ESRickman Joby · Lipan, TXBuilt 1995 · S/N 560-0311N474PECarolina Jet Partners LLC · Greenville, SCBuilt 1998 · S/N 560-0474N47PWWelkin Aviation LLC · Beaver, WVBuilt 1992 · S/N 560-0186N480RLBaseload Realty LLC · Corpus Christi, TXBuilt 1991 · S/N 560-0109N484MMN484mm LLC · Amarillo, TXBuilt 1998 · S/N 560-0491N492CGSwan Aviation LLC · Hattiesburg, MSBuilt 1995 · S/N 560-0308N496JHN496jh LLC · Clovis, NMBuilt 1998 · S/N 560-0496N49DKKts Holdings LLC · Elk Grove Village, ILBuilt 1990 · S/N 560-0075N49LDMckee Foods Transporation LLC · Collegedale, TNBuilt 2008 · S/N 560-0803N4TLMorningstar Aviation II Inc · Wilmington, DEBuilt 2001 · S/N 560-0587N4TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1991 · S/N 560-0105N4ZLFlying 5 Llcf · Johnson City, TNBuilt 1997 · S/N 560-0448N500FZDb N941jp LLC · Largo, FLBuilt 1989 · S/N 560-0018N500UJMmi Air LLC · Bakersfield, CABuilt 1990 · S/N 560-0062
Back to AD 2007-23-13