OpenAirDocs.org
AD 2011-23-07

Registered aircraft · 219

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:2011-23-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-23-07')
  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 262N104SGG200 LLC · Tulsa, OKBuilt 2008 · S/N 212N10RZPeregrine Falcon LLC Trustee · Boise, IDBuilt 2008 · S/N 258N10XQNinja Consulting LLC · Mesa, AZBuilt 2007 · S/N 169N110HABank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 035N119PSN119ps LLC · Miami Lakes, FLBuilt 1999 · S/N 009N11HMG200a LLC · Kirkland, WABuilt 2002 · S/N 080N1221QNonstop Leasing LLC · Elmhurst, ILBuilt 2001 · S/N 045N127PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 162N132JCBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 033N135FTTx Leasing LLC · Lilydale, MNBuilt 2007 · S/N 155N137WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 137N138TATeam Aero LLC · Shawnee, KSS/N 134N143CBGarudda LLC · Fort Lauderdale, FLBuilt 2001 · S/N 043N150CTBank 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, UTBuilt 2014 · S/N 311N150MTAshler Hills Investments LLC · Omaha, NEBuilt 2007 · S/N 220N151PWBsmt LLC · West Lake Hills, TXBuilt 2014 · S/N 310N153MSMendez & Sanchez Pc · Los Angeles, CABuilt 2006 · S/N 153N159JHLsh G200 LLC · Scottsdale, AZBuilt 2007 · S/N 159N161JCRailjet LLC · Durango, COBuilt 2008 · S/N 266N162GBSaib LLC · Prince George, VABuilt 2005 · S/N 117N165PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 165N16LVLiv Development LLC · Birmingham, ALBuilt 2016 · S/N 320N173JMSky Antelope Inc · Fort Lauderdale, FLBuilt 2005 · S/N 122N175MGBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 260N176QFBcl Aviation Partners LLC · Plantation, FLBuilt 2007 · S/N 176N178KRJrnd Corp · Lewes, DEBuilt 2007 · S/N 178N180LDEagle Peeble Aviation LLC · Shorewood, WIBuilt 2007 · S/N 164N1818MBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 129N186CWLegacy Global Aviation LLC · Boca Raton, FLBuilt 2003 · S/N 081N1901Buffalo Rock Company · Birmingham, ALBuilt 2006 · S/N 213N1927GDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 261N192RWGrove Aero LLC · Wilmington, DEBuilt 2005 · S/N 118N193SSFlight 4 LLC · Albuquerque, NMBuilt 2008 · S/N 193N199DFAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 128N1DKDonkaraphillips LLC · Tampa, FLBuilt 2007 · S/N 244N1EDDbct LLC · Youngstown, OHBuilt 2016 · S/N 324N200BAGl200mgmd LLC · Fort Lauderdale, FLBuilt 2002 · S/N 076N200ELN200el LLC · Trenton, NJBuilt 2004 · S/N 092N200GNMountain Management Group LLC · Phoenix, AZBuilt 2005 · S/N 120N200QACherokee LLC · Spicewood, TXS/N 130N200SWN200sw LLC · Loxahatchee, FLBuilt 2009 · S/N 221N204DDBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 139N205WADf Air LLC · Dover, DEBuilt 2005 · S/N 121
Back to AD 2011-23-07