OpenAirDocs.org
AD 2012-08-16

Registered aircraft · 238

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:2012-08-16')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-08-16')
  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.

N271GDDodson International Parts Inc · Rantoul, KSS/N 189N275HZCpns Aviation LLC · Nashville, TNS/N 215N275LRegistered aircraftN-number assigned (import), not yet registeredS/N 275N276BGBlue Star Air LLC · Artesia, NMBuilt 2004 · S/N 276N27LJContinental Jet LLC · Vero Beach, FLS/N 413N281JDDoan Logistics LLC · Houston, TXBuilt 1998 · S/N 125N298EFLear 007 J R LLC · Miami, FLBuilt 1997 · S/N 103N29LJDulcich Jet LLC · Clackamas, ORBuilt 2001 · S/N 240N303JJPrimus Capital LLC · Snowmass Village, COBuilt 2006 · S/N 309N30GJPublix Super Markets Inc · Lakeland, FLBuilt 2012 · S/N 419N314CMMedium Plane LLC · Carson City, NVBuilt 2005 · S/N 295N317ECBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 359N317MMFreedom Air LLC · Wilmington, DEBuilt 2001 · S/N 236N317MPAti Jet Inc · El Paso, TXBuilt 1999 · S/N 151N323RRSai Flight Services Inc · Greer, SCBuilt 1999 · S/N 160N325ERTailwinds LLC · Houston, TXBuilt 2007 · S/N 325N32SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 002N335SJScmv LLC · Arlington, VABuilt 2008 · S/N 335N33WLWl Flight Interests Inc · Tulsa, OKBuilt 2006 · S/N 299N341LJBank Of Utah Owner Trustee · Salt Lake City, UTS/N 341N343ECAscend Enterprises LLC · Wilmington, DEBuilt 2008 · S/N 343N352XRJacura Delaware Inc · Boca Raton, FLBuilt 2008 · S/N 352N356JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 356N357LALuxury Aero Collection LLC · Scottsdale, AZBuilt 2011 · S/N 396N357WPWh Air LLC · Clearwater, FLBuilt 2006 · S/N 300N358JAEast Shore Aviation LLC · Fort Lauderdale, FLS/N 358N358PColorado Structures Inc · Colorado Springs, COBuilt 2009 · S/N 374N359MMDm Aviation Services LLC · Kenner, LABuilt 1994 · S/N 047N360SNTailwinds LLC · Houston, TXBuilt 2008 · S/N 360N367LJG And J Aircraft Leasing LLC · Hillsboro Beach, FLS/N 367N372SCFje Enterprises Lp · Willis, TXS/N 60-373N375BWWm Walker Properties Inc · Owasso, OKBuilt 2001 · S/N 223N384JWN384jw LLC · Miami Beach, FLBuilt 1998 · S/N 130N388TRCareer Aviation Company Inc · Wilmington, DEBuilt 2010 · S/N 388N38SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 229N401SYTop Air Texas LLC · Glendale, CABuilt 2002 · S/N 60-256N404CDAti Jet Inc · El Paso, TXBuilt 2004 · S/N 277N405DCCos Air LLC · Boca Raton, FLBuilt 2008 · S/N 363N409JMJam-Air II LLC · Knoxville, TNS/N 418N415NPDodson International Parts Inc · Rantoul, KSS/N 024N415SGTom & Jerry Inc · Kansas City, KSBuilt 2005 · S/N 283N416GPMpc Equipment LLC · Norwalk, CTS/N 416N420KVTropicana Building II LLC · El Paso, TXBuilt 2000 · S/N 197N424LJSimard John · Austin, TXBuilt 2013 · S/N 424N425GSPonderosa Financial Services LLC · Salem, ORBuilt 2013 · S/N 425N43NRDodson International Parts Inc · Rantoul, KSBuilt 1994 · S/N 043N440MQAti Jet Inc · El Paso, TXBuilt 2006 · S/N 301N447LAMohan Aircraft LLC · Scottsdale, AZBuilt 2008 · S/N 60-329N448GL16 Angels LLC · Waukesha, WIBuilt 2000 · S/N 206N44RMN44rm LLC · Englewood, COBuilt 1993 · S/N 004
Back to AD 2012-08-16