OpenAirDocs.org
AD 2007-07-06 R1

Registered aircraft · 691

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

N136TTTyulyaev Vitaly N · Chesterfield, MOBuilt 2010 · S/N 411161N1374LB&B Exploration LLC · Lighthouse Point, FLBuilt 2006 · S/N 41579N137GBCalm Air Aviation · Nunica, MIBuilt 2006 · S/N 42538N1382VPropair400 LLC · Middletown, DEBuilt 2006 · S/N 41653N138AFSchultz David · Murfreesboro, TNBuilt 2006 · S/N 41702N1393WWvl Aviation Inc · Wilmington, DEBuilt 2006 · S/N 42531N1395VBliz Aviation LLC · Bend, ORBuilt 2006 · S/N 41667N139DCLegacy Air LLC · Missoula, MTBuilt 2005 · S/N 41056N13HEVam LLC · Bloomfield Hills, MIBuilt 2008 · S/N 411075N1401WLewes Adventures LLC · Wilmington, DEBuilt 2007 · S/N 41644N14100Ycb Wings LLC · Tavares, FLBuilt 2006 · S/N 41663N1411GTd Investments LLC · Oakdale, CAS/N 42556N1415KColumbia N1415k LLC · Leesburg, INBuilt 2006 · S/N 42547N1417WInternational Air Services Inc Trustee · Carson City, NVS/N 42523N141AMMckendrick Ain · Redwood City, CABuilt 2002 · S/N 40038N141PBL&M Columbia 181 LLC · Chandler, AZS/N 42066N1423ABijur David · Truckee, CABuilt 2007 · S/N 41719N142KMDearing Michael P · Anderson, TXBuilt 2008 · S/N 411082N142LCAerocareers Nfp · Columbia, ILBuilt 1998 · S/N 40003N1439CRempler David · Chandler, AZS/N 41618N143TTJ&W Outdoors LLC · Modesto, CABuilt 2010 · S/N 411154N1442EMt Zephyr Enterprises LLC · Yorktown, VABuilt 2006 · S/N 41698N1443TGrasso John A · Mount Laurel, NJBuilt 2007 · S/N 42534N1444NTruair LLC · Wilmington, DEBuilt 2007 · S/N 41764N14456Waller Harley Tp · Boston, MABuilt 2006 · S/N 41679N144AEMinard Stephan · Queen Creek, AZBuilt 2002 · S/N 40042N144LCPruetts Food Inc · Broken Bow, OKBuilt 2004 · S/N 41019N1452WMaxair LLC · Appleton, WIBuilt 2006 · S/N 41584N1454DCavu Aircraft LLC · Olympia, WABuilt 2007 · S/N 41743N1469WIrwin Alfred Homer · Lizella, GABuilt 2007 · S/N 41733N1473KTailwinds Aviation LLC · Punta Gorda, FLBuilt 2007 · S/N 41773N149LBWilde Timothy · Biloxi, MSBuilt 2008 · S/N 411064N150LCLipoff Jay I · Sarasota, FLBuilt 2005 · S/N 41501N151LCNewberry Homes LLC · Port Orange, FLBuilt 2007 · S/N 42501N1537RB & R Aero LLC · Keene, CAS/N 41778N153CMPruitt Michael A · Jacksonville, ALBuilt 2006 · S/N 41681N1547KEastern Stearman Inc Trustee · Leesburg, VABuilt 2007 · S/N 41747N1550MCunningham Larry Lyonal · Waco, TXBuilt 2007 · S/N 41717N1551FNewport Landing Investments LLC · Carencro, LABuilt 2007 · S/N 41721N1554GPhantom Air LLC · Lexington, NEBuilt 2007 · S/N 41785N1565SAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2007 · S/N 41761N156JBSully Air LLC · Atlanta, GABuilt 2001 · S/N 40019N157TTBluesky Air LLC · Georgetown, SCBuilt 2010 · S/N 411155N1584KJackson Aviation Inc · Dallas, TXBuilt 2007 · S/N 41779N1584YBacsikin Steven Kurt · Marine City, MIS/N 42564N158TAFerndock LLC · Monroe, LABuilt 2008 · S/N 411005N1599CThree Lakes Management LLC · Three Lakes, WIS/N 41753N1604CHodgens Craig · Edmond, OKBuilt 2006 · S/N 41697N160MCHaiasi LLC · Wilmington, DEBuilt 2010 · S/N 411160N161MCHamilton Clayton S · Carrizo Springs, TXBuilt 2008 · S/N 411020
Back to AD 2007-07-06 R1