AD 2019-08-13

Registered aircraft · 1,554

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:2019-08-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:2019-08-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.

N25SJR&T Aviation LLC · Pontiac, MIS/N 525A-0142N260AMQualitair LLC Trustee · MichelstadtBuilt 1998 · S/N 525-0260N262BKOmicron Business Services Inc · Winter Park, FLBuilt 1998 · S/N 525-0262N262DALr Forage Harvesting LLC · Energy, TXS/N 525B0562N263FBCrye-Leike South Inc · Memphis, TNBuilt 1998 · S/N 525-0263N264CEFly Invest Inc Trustee · Wilmington, DEBuilt 2019 · S/N 525B0584N267BGCardinal Scale Manufacturing Co · Webb City, MOBuilt 2021 · S/N 525-1078N26AUnlimited Boat Sales Inc · Page, AZBuilt 1999 · S/N 525-0325N26DTMdr Construction Inc · Columbia, MSBuilt 2013 · S/N 525-0814N26RLJs Aircraft LLC · Eden, NCBuilt 1997 · S/N 525-0207N273RJDylans Rv Center LLC · Waterford Works, NJBuilt 2003 · S/N 525A0160N274DTCentral Connecticut Aircraft LLC · Plainville, CTBuilt 2008 · S/N 525B0210N275LXLanier Flight Express LLC · Gainesville, GAS/N 525B0275N277VC9012newhere LLC · Wilmington, DEBuilt 2003 · S/N 525A-0169N278KThienes Engineering Inc · La Mirada, CABuilt 2003 · S/N 525-0527N278LNMonticello Air LLC · Napa, CABuilt 2007 · S/N 525A0338N279DLdt Aviation LLC · Coral Gables, FLBuilt 2006 · S/N 525B0070N27CJ411kc LLC · Tuscaloosa, ALBuilt 1999 · S/N 525-0311N27CNDn525 Capital Holdings LLC · Plano, TXBuilt 2023 · S/N 525B0694N27EWTextron Aviation Inc · Wichita, KSS/N 525-1425N27PLMwbp Foundation LLC · Tulsa, OKBuilt 2020 · S/N 525B0625N27VQAlcyone Trust Corp Trustee · Wichita, KSBuilt 2005 · S/N 525A0221N282WBRight Rudder Inc · Wilmington, NCBuilt 2019 · S/N 525B0588N283RACho Oyu LLC · San Antonio, TXBuilt 2008 · S/N 525B0283N285FWApex Cj1 LLC · Cypress, TXBuilt 2008 · S/N 525A0424N286NInfinity & Beyond LLC · South Bend, INBuilt 2007 · S/N 525B0190N287CBCottingham & Butler Insurance Services Inc · Dubuque, IABuilt 2017 · S/N 525-0942N287NNicholas Services LLC · Oxford, MSBuilt 2020 · S/N 525B0610N288G4m Aviation LLC · Fort Worth, TXBuilt 2001 · S/N 525A-0035N288STextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525B0922N289RTJp Aviation LLC · Petaluma, CAS/N 525A-0093N28CKC Star Aviation LLC · Evansville, INBuilt 1997 · S/N 525-0210N28DMMachavia Inc · Christiansted, VIBuilt 2007 · S/N 525B0142N28FDPacific Air Center LLC · Long Beach, CABuilt 2014 · S/N 525-0822N28QAHuff Air LLC · Uvalde, TXBuilt 1997 · S/N 5250215N28RKRd Aviation Lp · Redlands, CABuilt 1995 · S/N 525-0111N290CJLucky Stars LLC · Missoula, MTBuilt 2009 · S/N 525B0321N294CWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 525-0114N294PWSierra Papa II LLC · Bakersfield, CABuilt 2009 · S/N 525B0294N295DS4f Managment LLC · Salem, ORBuilt 1994 · S/N 525-0091N295LBuilding Corp LLC · Huntsville, TXBuilt 2002 · S/N 525A-0073N295MLCorning Companies LLC · Billings, MTBuilt 2019 · S/N 525-1043N298CJN298cj LLC · Friendswood, TXBuilt 2008 · S/N 525B0298N29MCValiair Lc Trustee · Casper, WYBuilt 2001 · S/N 525A-0042N2AZWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 525B0545N2BDOral Arts Dental Services LLC · Huntsville, ALBuilt 2007 · S/N 525A0358N2SYYocham J Scott · Mc Gregor, TXBuilt 2008 · S/N 525A0401N2ZBCitizen Aero Inc Trustee · Sheridan, WYBuilt 2021 · S/N 525-1101N300BVCj Bravo Victor LLC · Ridgeland, MSBuilt 2001 · S/N 525-0418N300FCDresden Aviation LLC · Atlanta, GABuilt 1998 · S/N 525-0248
Back to AD 2019-08-13