OpenAirDocs.org
AD 2007-07-13

Registered aircraft · 140

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:2007-07-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:2007-07-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.

N104SGG200 LLC · Tulsa, OKBuilt 2008 · S/N 212N10XQNinja 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 043N153MSMendez & Sanchez Pc · Los Angeles, CABuilt 2006 · S/N 153N159JHLsh G200 LLC · Scottsdale, AZBuilt 2007 · S/N 159N162GBSaib LLC · Prince George, VABuilt 2005 · S/N 117N165PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 165N173JMSky Antelope Inc · Fort Lauderdale, FLBuilt 2005 · S/N 122N176QFBcl 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 081N192RWGrove 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 128N200BAGl200mgmd 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 121N20BDHarbor Aircraft LLC · Wilmington, DEBuilt 2000 · S/N 014N20BLKiowa Aircraft Leasing LLC · Colorado Springs, COBuilt 2004 · S/N 094N213EPJssi Parts LLC · Chicago, ILBuilt 2001 · S/N 052N225JDAlliance Aviation Group LLC · Wilmington, DEBuilt 2000 · S/N 028N236PSHoffman Corp · Lake Oswego, ORBuilt 2010 · S/N 236N250HMPdkaa 250 Hm Partners LLC · Ketchum, IDBuilt 2008 · S/N 217N251LBAerotrust Services Corp Trustee · Wilmington, DEBuilt 2000 · S/N 024N278GACoramdeo LLC · Dallas, TXBuilt 2002 · S/N 078N280LTMcp Investments LLC · Sugar Land, TXBuilt 2002 · S/N 071N299PSMbv Aviation LLC · Waco, TXBuilt 2006 · S/N 136N2BGCalifornia Hotel And Casino · Las Vegas, NVBuilt 2002 · S/N 064N2GPerformance Aviation LLC · Richmond, VABuilt 2004 · S/N 106N300BJRa2024 LLC · Tomball, TXBuilt 2002 · S/N 049N30MZWildwood Yonder LLC · San Francisco, CABuilt 2009 · S/N 226N311MKSkys The Limit Aviation LLC · Dallas, TXBuilt 2004 · S/N 095N318JFAibonito Aviation LLC · San Juan, PRBuilt 2004 · S/N 093N324WKDollar Air LLC · Menlo Park, CABuilt 2005 · S/N 108N32BGBigs Property LLC · Norht Sioux City, SDBuilt 2006 · S/N 138
Back to AD 2007-07-13