OpenAirDocs.org
AD 2019-03-13

Registered aircraft · 79

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-03-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-03-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.

N100GXBrulecreek Aviation LLC · Park City, UTBuilt 2007 · S/N 228N100SRRayman Steven M Trustee · Big Rock, ILBuilt 2007 · S/N 227N101RXGb Aviation LLC · Milledgeville, GABuilt 2008 · S/N 262N10RZPeregrine Falcon LLC Trustee · Boise, IDBuilt 2008 · S/N 258N150CTBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 208N150GAJa Aviation Holdings LLC · Orlando, FLBuilt 2008 · S/N 252N150GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 201N150JNG150mt LLC · Franklin, TNBuilt 2006 · S/N 212N150LPTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 311N150MTAshler Hills Investments LLC · Omaha, NEBuilt 2007 · S/N 220N151PWBsmt LLC · West Lake Hills, TXBuilt 2014 · S/N 310N161JCRailjet LLC · Durango, COBuilt 2008 · S/N 266N16LVLiv Development LLC · Birmingham, ALBuilt 2016 · S/N 320N175MGBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 260N1901Buffalo Rock Company · Birmingham, ALBuilt 2006 · S/N 213N1927GDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 261N1DKDonkaraphillips LLC · Tampa, FLBuilt 2007 · S/N 244N1EDDbct LLC · Youngstown, OHBuilt 2016 · S/N 324N211TAG150-223 LLC · Easton, MDBuilt 2007 · S/N 223N217MSS&S Aviation LLC · Florence, ALBuilt 2007 · S/N 217N222HKNdw Hawk LLC · Laurel, MSBuilt 2008 · S/N 248N224GGGator Tracks LLC · Destin, FLBuilt 2007 · S/N 224N22GGoodyear Tire & Rubber Co · Akron, OHBuilt 2009 · S/N 282N247PSRed Clay Aviation LLC · Pineville, NCBuilt 2006 · S/N 215N24GGoodyear Tire & Rubber Co · Akron, OHBuilt 2010 · S/N 289N27KB3kb Investments LLC · Wilmington, DEBuilt 2010 · S/N 291N285GAPfc Holdings LLC · Bloomfield Hills, MIBuilt 2009 · S/N 285N286JJHoran John J Jr · Dallas, TXBuilt 2012 · S/N 303N29JWSchussboomer Systems Inc · Anacortes, WABuilt 2006 · S/N 205N2HZHerzog Contracting Corp · Saint Joseph, MOBuilt 2006 · S/N 216N326KHGator One Air LLC · Destin, FLBuilt 2007 · S/N 230N357PTBenson Legacy LLC · Fort Wayne, INBuilt 2013 · S/N 309N360AVBsc Enterprises LLC · Tulare, CABuilt 2007 · S/N 240N365SSStallings Robert W · Frisco, TXBuilt 2008 · S/N 268N390KXKnight Air LLC · Phoenix, AZBuilt 2012 · S/N 305N428CJNo Res LLC · Scottsdale, AZBuilt 2008 · S/N 256N428JDDewberry Air LLC · Atlanta, GABuilt 2006 · S/N 210N449BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 274N469DMNac Flight Service LLC · Madison, MSBuilt 2008 · S/N 257N480JJJem Aviation III LLC · Thomasville, NCBuilt 2008 · S/N 270N501RPPts As LLC · Reading, PABuilt 2013 · S/N 308N503RPPts As LLC · Reading, PABuilt 2013 · S/N 307N508RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 306N518KHGolden Eagle Management LLC · Missoula, MTBuilt 2007 · S/N 229N530LDModena Aviation LLC · Leander, TXBuilt 2006 · S/N 203N557GABank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 292N57RGBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 281N581SFFkm Enterprises LLC · North Oaks, MNBuilt 2008 · S/N 250N598KDWildhorse Air II LLC · Minden, NVBuilt 2014 · S/N 313N626LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 277
Back to AD 2019-03-13