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.

N358HAElsy Equipment LLC · Owasso, OKBuilt 1999 · S/N 525-0358N358JJCoral Air LLC · Little Rock, ARBuilt 2008 · S/N 525B0267N358K358k LLC · Salem, ORBuilt 2010 · S/N 525A0475N358WCNorton Packaging Inc · Hayward, CABuilt 2006 · S/N 525A0306N359GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 525B0766N35CTBoulder Charters LLC · Billings, MTBuilt 2002 · S/N 525A-0120N360CKGrigry Energy Inc · Monahans, TXBuilt 2007 · S/N 525B0180N360SHRkjm LLC · Superior, NEBuilt 1997 · S/N 525-0201N360TDKana Hotels Inc · Knoxville, TNBuilt 2011 · S/N 525B0360N361TLCj3@0061 LLC · Saint Johns, MIBuilt 2006 · S/N 525B0061N363ALNunes Company Inc · Salinas, CABuilt 2013 · S/N 525B-0409N363BSMjti LLC · Santa Rosa, CABuilt 2017 · S/N 525-0961N363RHGuarantee Management Services LLC · Glenview, ILS/N 525A0492N363VPPinnacle Aviation LLC · Charleston, SCBuilt 2007 · S/N 525A-0363N364BCNii Aero LLC · Seattle, WABuilt 2012 · S/N 525A0505N364PKSky Hawk LLC · Moody, ALBuilt 1999 · S/N 525-0320N365SMIntegrated Transportation Services LLC · Tupelo, MSBuilt 2007 · S/N 525-0658N365SNNice Neighbors LLC · Wilmington, NCBuilt 1996 · S/N 525-0121N366MPMartins Famous Pastry Shoppe Inc · Chambersburg, PABuilt 2019 · S/N 525B0575N369MNL J Associates Inc · Latrobe, PABuilt 2009 · S/N 525B0314N36RGJrb Of Montana LLC · Wooster, OHBuilt 1996 · S/N 525-0139N36TXFrog Air LLC · Amarillo, TXBuilt 1996 · S/N 525-0153N370MRPacific Cataract And Laser Institute Inc Pc · Chehalis, WABuilt 2012 · S/N 525B0385N370RPSmithers Logistics LLC · Akron, OHBuilt 2007 · S/N 525A0370N371RMFwd&L 525 LLC · Cataula, GABuilt 2015 · S/N 525-0900N373AFSe Aero II LLC · Atoka, OKBuilt 1999 · S/N 525-0308N373AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 525B0737N373CHLandmasters Aviation Services LLC · Deland, FLBuilt 2017 · S/N 525B0516N377PGJackalope Air LLC · Afton, WYBuilt 2022 · S/N 525-1133N377PLTide Rock Travel LLC · Solana Beach, CABuilt 2009 · S/N 525B0312N379BBuckle Inc · Kearney, NEBuilt 2008 · S/N 525B0212N379RCarelli Aviation LLC · Tampa, FLBuilt 2008 · S/N 525A0421N379SMBaker Aviation LLC · Bluff City, TNBuilt 2012 · S/N 525B0379N381SCWoodruff Aviation LLC · Augusta, ARBuilt 2007 · S/N 525B0133N383BPMarshall Engines Inc · Kearney, NEBuilt 2005 · S/N 525B0042N383CJAsj Aviation LLC · Dover, DEBuilt 2012 · S/N 525B0383N386TARockit X LLC · Birmingham, ALBuilt 2017 · S/N 525B0518N387CBCottingham & Butler Insurance Services Inc · Dubuque, IABuilt 2019 · S/N 525B0601N388KTCj Leasing LLC · Moody, ALBuilt 2003 · S/N 525A0172N38HDMeans To Go LLC · Altoona, PABuilt 2013 · S/N 525B0407N38QA7 Seas Aviation LLC · Monroe, GABuilt 2004 · S/N 525A0214N38RLAtg112 LLC · Reno, NVBuilt 2001 · S/N 525-0420N390CJMag Air LLC · Concord, NCBuilt 2026 · S/N 525B0900N390KTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 525-0813N392MGStarflite Aviation LLC · Beaufort, NCBuilt 2012 · S/N 525B0392N392RGWhitt Aviation LLC · Lannon, WIBuilt 1999 · S/N 525-0340N392SMHarrison Aviation LLC · Yuma, AZBuilt 2000 · S/N 525-0392N393SGN393sg LLC · Carlsbad, CABuilt 2012 · S/N 525B0377N394GAAircraft Owners And Pilots Association · Frederick, MDBuilt 2013 · S/N 525-0807N399ABRkwa LLC · Shreveport, LABuilt 2018 · S/N 525-0990
Back to AD 2019-08-13