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.

N330APJ19 Aviation LLC · Austin, TXBuilt 2004 · S/N 105N330WJWaitt Joan T Trustee · La Jolla, CABuilt 2000 · S/N 022N33DYReal Estate And Renovate · Bigfork, MTBuilt 2004 · S/N 103N357JGRegistered aircraftS/N 171N358TDYang Chi · Lafayette, COBuilt 2007 · S/N 170N35PSSpotlight Capital LLC · Flower Mound, TXBuilt 2008 · S/N 209N35RFNational Aircraft Leasing LLC #2 · Seattle, WABuilt 2002 · S/N 061N361RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 179N366FBMbl Financial LLC · Highland, UTBuilt 2002 · S/N 075N384JKTravelconfirm Aerolease Inc · Portland, ORBuilt 2002 · S/N 069N403SLRegistered aircraftBuilt 2000 · S/N 013N409BMKsnl Aero LLC · Shawnee, OKBuilt 2002 · S/N 059N415PRDlh N415pr LLC · Cortland, NYBuilt 2000 · S/N 017N425JRTb Equico LLC · Beaumont, TXBuilt 2001 · S/N 055N42DH58dh LLC · Atlanta, GABuilt 2011 · S/N 250N445STNp Aviation II LLC · Atlanta, GABuilt 2005 · S/N 114N454THG200 Aviation LLC · Gentry, ARBuilt 2004 · S/N 096N468JJPdl Holdings Fl LLC · Tampa, FLBuilt 2005 · S/N 123N479PRNellie Navigation LLC · Naples, FLBuilt 2000 · S/N 008N500AGCd 321 LLC · Cypress, TXBuilt 2007 · S/N 158N513RBBeasley Roger K · Austin, TXBuilt 2002 · S/N 060N513UBC Street Holdings LLC · Newport Beach, CABuilt 2005 · S/N 126N531MBCaleah Acquisitions LLC · Savannah, GABuilt 2001 · S/N 044N54CMGac Wings LLC · Boca Raton, FLBuilt 2001 · S/N 042N573PTLoxodonta Aviation LLC · Vero Beach, FLBuilt 2005 · S/N 127N597NEFiwc26 LLC · El Paso, TXBuilt 2006 · S/N 144N597RBBaugh Aviation Services LLC · Orem, UTBuilt 2002 · S/N 068N5BCTsb Aviation Inc · Madera, CABuilt 2003 · S/N 084N606HPMustang 99 LLC · Austin, TXBuilt 2005 · S/N 116N612FAGroup Project Eight LLC · Bountiful, UTBuilt 2009 · S/N 213N619KSBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 151N631DVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 166N65ERM G Investment Properties LLC · Van Nuys, CABuilt 2004 · S/N 100N663SBKka Enterprises LLC · Flower Mound, TXBuilt 2002 · S/N 062N671BP671bp LLC · Cypress, TXBuilt 2000 · S/N 031N672PSFort Stephenson Air LLC · Chattanooga, TNBuilt 1999 · S/N 010N679MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 156N67LRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 102N682RVKr Escapes LLC · Wilmington, DEBuilt 2006 · S/N 150N688HLH&L 168 LLC · Las Vegas, NVBuilt 2011 · S/N 247N699DB699db LLC · Vienna, VABuilt 2001 · S/N 056N703MSHillpointe Aviation Fl LLC · Winter Park, FLBuilt 2010 · S/N 235N707MZAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2008 · S/N 173N707SQFreedom 200 LLC · Dallas, TXBuilt 2003 · S/N 087N710RHValiair Lc Trustee · Casper, WYBuilt 2006 · S/N 141N710TCCd 321 LLC · Austin, TXBuilt 2009 · S/N 230N716JWTango 280 Holdings LLC · Spring, TXBuilt 2008 · S/N 211N718CFMustang Equipment LLC · Dallas, TXBuilt 2002 · S/N 070N721CCN721 Cc LLC · Lewes, DEBuilt 2003 · S/N 088N723RHRadco Aviation LLC · Atlanta, GABuilt 2002 · S/N 066
Back to AD 2007-07-13