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.

N912AVAeropus LLC · Rancho Santa Fe, CABuilt 2008 · S/N 411006N912CMRossi Peter E · Los Angeles, CABuilt 2007 · S/N 41790N913GMVerrone Lee C · Mount Vernon, NYS/N 40010N913PMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2006 · S/N 42524N915GMMosaviation LLC · Helena, MTBuilt 2004 · S/N 41015N915KBLacy Robert T · Scottsdale, AZBuilt 2008 · S/N 421012N915MLQcc Investments LLC · Hattiesburg, MSBuilt 2008 · S/N 411024N916GMFavero Joseph · Jasper, TNBuilt 2004 · S/N 42049N918LVLandreth David L · Houston, TXBuilt 2006 · S/N 41578N91YPAircraft Parts Store LLC · Jacksonville, FLS/N 41520N920MMDp Aviation LLC · Trenton, NCS/N 42558N921DZPk Helicopters LLC · Graford, TXBuilt 2006 · S/N 41695N921GBWalsh Brendan Michael · Yuma, AZBuilt 2007 · S/N 41759N923PMNeuhaus George W · Skokie, ILBuilt 2005 · S/N 41526N924EBEagle Enterprise Group LLC · Houston, TXBuilt 2006 · S/N 41708N925RJHammer Neil A · Alexandria, MNBuilt 2002 · S/N 40048N927KCFritz Rodney A · Lanark, ILBuilt 2006 · S/N 41659N927MBGlobal Aircraft Management And Operations LLC · Thomasville, GABuilt 2001 · S/N 40031N928PCBayou Self Aviation LLC · Covington, LABuilt 2008 · S/N 411003N932ACHodge&Langley Law Firm Pc · Spartanburg, SCBuilt 2008 · S/N 411021N936DWTreeline Aviation LLC · Grimes, IABuilt 2003 · S/N 40070N941TCKupau Inc · Kailua Kona, HIBuilt 2002 · S/N 40049N957JMLots-A-Knots Aviation LLC · Watkinsville, GABuilt 2006 · S/N 41699N959PMD W Lusk Contracting LLC · Snowflake, AZBuilt 2007 · S/N 41728N95EERjt&E LLC · Spring, TXBuilt 2004 · S/N 42036N95UXColumbiajs LLC · Houston, TXBuilt 2007 · S/N 41786N961TTLupia Raul H · Raleigh, NCBuilt 2004 · S/N 42054N964SGWing Nuts Flying Club Ltd · North Chesterfield, VABuilt 2006 · S/N 42518N969ABSky Blue Ventures LLC · Georgetown, SCBuilt 2008 · S/N 411118N974WFVictory Aviation LLC · Winchester, VABuilt 2006 · S/N 42527N975MCChristopher Michael W · Nicholasville, KYBuilt 2007 · S/N 42560N988PZeve Bradley · Carmel, CABuilt 2005 · S/N 41094N98UTM&P Investment Partners LLC · Eastsound, WABuilt 2008 · S/N 411051N991AJPc Aviation LLC · Kanarraville, UTBuilt 2006 · S/N 41645N991DFMbd Consulting LLC · Pell City, ALBuilt 2006 · S/N 41626N997JKEastern Stearman Inc Trustee · Leesburg, VABuilt 2005 · S/N 41108N997MMDavis Transportation Services LLC · Cokeville, WYBuilt 2006 · S/N 41705N999GLGarmin International · Olathe, KSBuilt 2004 · S/N 41034N999LCJust Plane Aviation LLC · Baldwin, MIS/N 40032N99MMColumbia Air LLC · Winter Park, FLBuilt 2008 · S/N 411032N99VLBevan David B · Biltmore Forest, NCBuilt 2009 · S/N 411146
Back to AD 2007-07-06 R1