OpenAirDocs.org
AD 2008-13-16

Registered aircraft · 120

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:2008-13-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:2008-13-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.

N104RJHalrive Air LLC · Boca Raton, FLBuilt 2012 · S/N 422N106FFAerial Holdings Lj Inc · Wilmington, DEBuilt 2010 · S/N 375N113DJ3d Jets LLC · Orchard Park, NYBuilt 2007 · S/N 307N160EMTjh Falcon2 LLC · San Antonio, TXBuilt 1999 · S/N 149N160SJEcho Acquisitions LLC · Dover, DEBuilt 2008 · S/N 345N169LJSelect Jet Lease II LLC · Grand Rapids, MNBuilt 2000 · S/N 60-169N189SBSky Ballas LLC · El Paso, TXBuilt 2002 · S/N 210N1JBN1jb LLC · Winter Park, FLBuilt 2013 · S/N 428N207AWHahn Automotive Fs LLC · Rochester, NYBuilt 2005 · S/N 282N208BHAti Jet Inc · El Paso, TXBuilt 2000 · S/N 208N213RTExecuflight LLC · Monroeville, ALBuilt 2008 · S/N 344N216DYPhoenixair II LLC · Palm Bay, FLBuilt 2001 · S/N 218N225GPWh Air LLC · Sanford, FLBuilt 1999 · S/N 154N242CSTeuseas Jet LLC · Saint Petersburg, FLBuilt 1996 · S/N 089N247MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 051N260GDAviation Company Inc · Cheyenne, WYBuilt 2001 · S/N 220N276BGBlue Star Air LLC · Artesia, NMBuilt 2004 · S/N 276N281JDDoan Logistics LLC · Houston, TXBuilt 1998 · S/N 125N303JJPrimus Capital LLC · Snowmass Village, COBuilt 2006 · S/N 309N30GJPublix Super Markets Inc · Lakeland, FLBuilt 2012 · S/N 419N317ECBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 359N317MMFreedom Air LLC · Wilmington, DEBuilt 2001 · S/N 236N323RRSai Flight Services Inc · Greer, SCBuilt 1999 · S/N 160N325ERTailwinds LLC · Houston, TXBuilt 2007 · S/N 325N335SJScmv LLC · Arlington, VABuilt 2008 · S/N 335N33WLWl Flight Interests Inc · Tulsa, OKBuilt 2006 · S/N 299N343ECAscend 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 396N358PColorado Structures Inc · Colorado Springs, COBuilt 2009 · S/N 374N360SNTailwinds LLC · Houston, TXBuilt 2008 · S/N 360N388TRCareer Aviation Company Inc · Wilmington, DEBuilt 2010 · S/N 388N401SYTop 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 363N415SGTom & Jerry Inc · Kansas City, KSBuilt 2005 · S/N 283N420KVTropicana 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 425N440MQAti Jet Inc · El Paso, TXBuilt 2006 · S/N 301N451BDDeluca Aviation LLC · Camden, DEBuilt 2006 · S/N 297N461MCAti Jet Inc · El Paso, TXBuilt 2005 · S/N 284N473FCBond-Coat Inc · Odessa, TXBuilt 2007 · S/N 322N500CWN500cw LLC · Miami Beach, FLBuilt 1998 · S/N 133N502ABLj60-318 LLC · Memphis, TNBuilt 2007 · S/N 318N503ABLj60-311 LLC · Memphis, TNBuilt 2006 · S/N 311N508ABLj60-273 LLC · Memphis, TNBuilt 2004 · S/N 273N509ABLj60-073 LLC · Memphis, TNBuilt 1996 · S/N 073N511BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 259031
Back to AD 2008-13-16