OpenAirDocs.org
AD 2008-07-11 R1

Registered aircraft · 545

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-07-11-R1')
    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-07-11-R1')
  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.

N100JADolce Vita Assets LLC · Saint Petersburg, FLBuilt 2007 · S/N 865N100YCFirst View Aviation LLC · Burlington, COBuilt 1999 · S/N 281N101JEJeva Air Corp · Plantation, FLBuilt 2004 · S/N 569N1056BCorral Ventures LLC · Atlantic Beach, FLBuilt 2003 · S/N 499N107HMSterling Air Service LLC · Corpus Christi, TXBuilt 1999 · S/N 248N108JCR J Young Co · Nashville, TNBuilt 2008 · S/N 883N10FBRad Runner LLC · Newton, NCBuilt 2006 · S/N 748N111WGAhuva LLC · Port Alsworth, AKBuilt 2004 · S/N 555N112VFVictor Foxtrot LLC · Scott City, KSBuilt 2008 · S/N 882N1130DDevonair Enterprises LLC · Rockford, MIBuilt 2007 · S/N 823N116SKAir Methods LLC · Greenwood Village, COBuilt 1995 · S/N 116N11898Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 456N118APRoadkill Aviation LLC · Indianapolis, INBuilt 1997 · S/N 175N119QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 119N11AGDg + Ag LLC · Albuquerque, NMBuilt 2000 · S/N 343N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120N1211AStar Child 3 LLC · Sanibel, FLBuilt 2005 · S/N 663N123CFPc-12 Aircraft LLC · Sanford, FLS/N 286N1245XKalinin Partners LLC · Juneau, AKBuilt 2003 · S/N 496N124UVGuardian Flight LLC · Lewisville, TXS/N 124N125PZStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 1998 · S/N 209N126ALShort Hop LLC · Bellevue, WABuilt 2007 · S/N 863N1273ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 603N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629N12DZJmp Aircraft Service LLC Trustee · Wasilla, AKBuilt 2001 · S/N 390N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117N12JDYellow Transportation Services Inc · Milwaukee, WIBuilt 1998 · S/N 228N142LTJk Aviation LLC · Manteca, CAS/N 312N146PCLmco · Vandenberg Afb, CABuilt 1996 · S/N 146N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149N14RDLiftwing Aircraft Holdings LLC · Bellevue, WABuilt 2001 · S/N 384N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153N156SBSpark Aviation LLC · West Harrison, NYS/N 156N156WLCl 245 Partners LLC · Erie, COS/N 245N161AJGruener Garrett · Berkeley, CABuilt 1997 · S/N 161N162PBPapa Bravo Aviation LLC · Fort Lauderdale, FLBuilt 1996 · S/N 162N166SBNew Cingular Wireless Pcs LLC · Anchorage, AKBuilt 1999 · S/N 310N167AREdgemont Aviation LLC · Wilmington, DEBuilt 1999 · S/N 279N172JSCmfl LLC · Montgomery, ALBuilt 1997 · S/N 171N172PBLocker Inc · Muleshoe, TXBuilt 1997 · S/N 172N175ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 566N178MHRegistered aircraftBuilt 2008 · S/N 875N17DPWde Aviation LLC · Atlanta, GABuilt 2005 · S/N 648N18007Stancil Builders Inc · Angier, NCBuilt 2000 · S/N 377N185PBStellar Envoy LLC · Arvada, COBuilt 1997 · S/N 185N188PCTimeless USA LLC · Wilmington, DEBuilt 1997 · S/N 188N18DSN18ds LLC · Mcminnville, ORBuilt 2007 · S/N 797N190ASInterport Aviation LLC · Newark, NJBuilt 2006 · S/N 727N190PEUS Department Of The Interior · Boise, IDBuilt 1997 · S/N 190
Back to AD 2008-07-11 R1