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.

N151GMHei Aviation LLC · Powell, OHBuilt 2014 · S/N 525B0452N152KVPlane House LLC · Indianapolis, INBuilt 1996 · S/N 525-0152N153CJAbbey Air Inc · Birmingham, ALBuilt 2003 · S/N 525A0153N153TJDavis Air LLC · Vero Beach, FLBuilt 2007 · S/N 525A0377N155BWPoet Inc · Sioux Falls, SDBuilt 2018 · S/N 525-0988N155CGBigees Air LLC · Sioux Falls, SDBuilt 1997 · S/N 525-0214N156MLAir Miles LLC · River Falls, WIBuilt 1996 · S/N 525-0156N157TWHf Air LLC · Fresno, CABuilt 2007 · S/N 525B0157N159JSB&L Adventures LLC · Sealy, TXBuilt 2005 · S/N 525B0038N15EDClearview Aviation Group LLC · Peachtree City, GABuilt 2015 · S/N 525-0855N15WEFirstrike Aviation LLC · Tulsa, OKBuilt 2014 · S/N 525-0847N15YDN15yd LLC · Lewes, DES/N 525A0336N15ZZShamrock Air LLC · Arnold, MOBuilt 2008 · S/N 525B0221N160BRDft LLC · Central Point, ORBuilt 2014 · S/N 525B0454N162CBKjt Aviation LLC · Beaumont, TXBuilt 2007 · S/N 525A0353N162ECCitation Dreams LLC · Inlet Beach, FLBuilt 2005 · S/N 525B0026N16WBPacebook Aviation LLC · Albany, GABuilt 2016 · S/N 525-0905N170MRN170mr LLC · Bend, ORS/N 525A0170N170MUCitationjet 525 LLC · Wilmington, DEFirst renewal noticeBuilt 1996 · S/N 525-0170N170TMJba LLC · Berkeley, CABuilt 2002 · S/N 525A0100N174AACorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N 525B0196N174SJSierra Juliet LLC · Greeley, COBuilt 2007 · S/N 525B0174N175AACorsair Two LLC · Hillsboro, ORBuilt 2006 · S/N 525B0068N175RDGaltstream LLC · Greenwood Village, COBuilt 2009 · S/N 525B0310N176BKWildcat Aviation LLC · Colby, KSBuilt 2008 · S/N 525B0232N1776WRegistered aircraftBuilt 2006 · S/N 525B0093N177VVDodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 525-0182N178MPAirtrust LLC - 6 - Series 6 Trustee · Sheridan, WYBuilt 2022 · S/N 525B0681N179ERMedd II Aircraft LLC · Zelienople, PABuilt 2009 · S/N 525B0335N179WCBailburch Aviation LLC · Little Rock, ARBuilt 2005 · S/N 525B0025N17LJGenetech Animal Reproduction LLC · Purcell, OKBuilt 2000 · S/N 525-0372N17QCOncourse Air LLC · Rogers, ARBuilt 2016 · S/N 525B0509N17VBN17vb LLC · Nacogdoches, TXBuilt 1997 · S/N 525-0206N181WENew Pig Corp · Tipton, PABuilt 2018 · S/N 525B0553N181WSSierra Western Aero LLC · Wentzville, MOBuilt 2019 · S/N 525B0592N183TXCrump Properties LLC · Jasper, ALS/N 525A0183N18466Pantaxios LLC · Spencerport, NYBuilt 2019 · S/N 525-1034N1863WKansas State University · Salina, KSBuilt 2025 · S/N 525B0749N1865CHotel Alpha LLC · Tampa, FLBuilt 2007 · S/N 525-0647N186DLAesop LLC · Las Vegas, NVBuilt 2013 · S/N 525-0803N186TWTnp Aviation LLC · Valdosta, GABuilt 2001 · S/N 525-0416N1875CFalcon Ridge LLC · Longview, TXBuilt 2011 · S/N 525A0488N187MCAe Aircraft LLC · Longview, TXBuilt 1998 · S/N 525-0276N188MPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 525A0483N188SBHigh Flyers LLC · Hobbs, NMBuilt 2015 · S/N 525-0879N189MSAviation II Inc · Tulsa, OKBuilt 2003 · S/N 525A0189N18KStrata Aviation LLC · Durham, NCBuilt 2023 · S/N 525B0689N18TFAirflite Financial Company LLC · Alpena, MIBuilt 2001 · S/N 525A0014N1933SSunflower Sand LLC · Akron, OHBuilt 2021 · S/N 525B0634N193PPMarietta Silos LLC · Marietta, OHBuilt 2003 · S/N 525A0192
Back to AD 2019-08-13