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.

N799ERegistered aircraftBuilt 2006 · S/N 41620N799MEVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 41716N7NRHodgkins Charlie Lee III · Strawn, TXBuilt 2005 · S/N 41103N7ZDEdgerton Emmett Cecil III · Dunn, NCBuilt 2005 · S/N 42068N802SSBlue Sky Inc · Wilmington, DEBuilt 2005 · S/N 41063N804LMMti Leasing LLC · Atlanta, GABuilt 2007 · S/N 41718N807RBAscensio LLC · Tyler, TXBuilt 2001 · S/N 40009N812PVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2007 · S/N 41737N814HHZerbe Grant · Frazer, MTBuilt 2005 · S/N 41095N816JTRed Angel Wings LLC · Colorado Springs, COS/N 41058N816SFTbf Aviation LLC · Park City, UTBuilt 2008 · S/N 411115N817STTaberna John P · Parma, IDBuilt 2007 · S/N 41724N822CEElwell Charles W Jr · Destin, FLBuilt 2007 · S/N 41794N823DHRo-Jo Scientific Consulting LLC · Indianapolis, INBuilt 2003 · S/N 42021N824XLeaf Aviation LLC · Henderson, NVBuilt 2006 · S/N 41623N827APelican Flyers LLC · Metairie, LABuilt 2002 · S/N 40050N82PHHarold Hart & Associates Inc · Tampa, FLBuilt 2005 · S/N 42082N831JDMartinez Alexander J · Cumberland, MEBuilt 2006 · S/N 42506N836RFNuage Software Corp · Saint Petersburg, FLBuilt 2002 · S/N 40051N838VKHepburn Joseph · Towanda, KSBuilt 2007 · S/N 42559N842XBarras Lawrence S · San Jose, CABuilt 2007 · S/N 41723N845LLLepp Curtis Wayne · New Braunfels, TXBuilt 2003 · S/N 42019N847PTPt Endeavors LLC · Saint Petersburg, FLBuilt 2007 · S/N 42551N855SKFx Energy Group LLC · Franktown, COBuilt 2006 · S/N 41700N857AZBb Air Group LLC · Aberdeen, SDBuilt 2005 · S/N 41078N858NDAero Assurance Services LLC Trustee · Yakima, WAS/N 41652N859JGLarocca Sandro · Yardley, PAS/N 42069N85EABarley Aviation LLC · Sunset, SCBuilt 2008 · S/N 411050N86DEHardwood Transport LLC · Caledonia, NYBuilt 2008 · S/N 411027N86KCMalick Jewell E · Heath, TXBuilt 2006 · S/N 41617N86LPFields To Flight LLC · Walnut Creek, CABuilt 2008 · S/N 411089N86WTSdgt LLC · Roseburg, ORS/N 41628N8725Van Bortel Aircraft Inc · Arlington, TXBuilt 2006 · S/N 41605N872YHoward Donald · Farmington, NMS/N 41047N881RLInternational Services Management LLC · Heath, TXBuilt 2007 · S/N 41738N886MLMichael Lam Md Apc · Los Altos Hills, CABuilt 2001 · S/N 40012N888YBIdea Cooks LLC · Boulder, COBuilt 2006 · S/N 41668N88CEN3mf LLC · Lewes, DEBuilt 2006 · S/N 42536N891TPParsons Aviation LLC · Hooks, TXBuilt 2006 · S/N 42516N898CWColumbia 400 Angel LLC · Tucson, AZBuilt 2005 · S/N 41064N898RFDavis Russell C · Bakersfield, CABuilt 2007 · S/N 41711N899BWAg Aviation LLC · Orlando, FLBuilt 2006 · S/N 41601N89HWHw Air Lc · Salt Lake City, UTBuilt 2001 · S/N 40016N89KCFitzpatrick Tod · Las Vegas, NVBuilt 2009 · S/N 411123N89PFBrown Jeffrey T · Sherman, ILBuilt 2003 · S/N 40074N8UZAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 42050N8WYStockhouse James B · Jackson, WYBuilt 2002 · S/N 40060N9003Andreotti Mark · Colusa, CABuilt 2005 · S/N 41074N905PCLamb Robert Duncan · Kiln, MSBuilt 2003 · S/N 42026N910MLSegall Aviation LLC · Baltimore, MDBuilt 2008 · S/N 411031
Back to AD 2007-07-06 R1