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.

N400NZChandler Builders Inc · Ruidoso, NMBuilt 2006 · S/N 41634N400PLPennae LLC · Montgomery, TXBuilt 2008 · S/N 411078N400PTRon Wright LLC · Dayton, NVBuilt 2007 · S/N 41744N400RDBhr Leasing Corp · Wilmington, DES/N 41519N400RRJax Transport LLC · Amarillo, TXBuilt 2007 · S/N 41729N400TRAerial Ventures 1 Ltd · Austin, TXBuilt 2004 · S/N 41037N400TVA & A Farms Inc · Arbuckle, CABuilt 2004 · S/N 42041N400UKInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 41062N400VEBoondock Enterprises LLC · Boise City, OKBuilt 2007 · S/N 41727N401BHHarvey William G · Pipersville, PABuilt 2006 · S/N 41593N401CMRmc Holdings Inc · Denver, COBuilt 2004 · S/N 41016N401CRSpringrock LLC · Redlands, CABuilt 2006 · S/N 41712N401PFBumpy Aviation LLC · Kalispell, MTBuilt 2006 · S/N 41647N403JAEscape Aviation Leasing LLC · Overland Park, KSBuilt 2008 · S/N 411067N403KHLaw Office Of Rick Morin Pc · Newport Beach, CABuilt 2008 · S/N 411116N403MCHuntington Aviation LLC · Irving, TXBuilt 2009 · S/N 411135N404JALamoreaux Gene H Trustee · Mckinney, TXBuilt 2008 · S/N 411093N404MJParadise Boating Co · Chicago, ILBuilt 2008 · S/N 411074N405TWFlicksville Flyers Inc · Bangor, PABuilt 2008 · S/N 411105N407KMGough Tecnologies Inc · Winston Salem, NCBuilt 2004 · S/N 41012N408ABRite A Way Services Inc · Riverside, CAS/N 411090N409HAFalcon Flight And Investments LLC · Lewes, DEBuilt 2008 · S/N 411039N409SJKirsh & Kirsh P C · Indianapolis, INBuilt 2005 · S/N 42084N409TTMad Dog Air LLC · Spotsylvania, VABuilt 2009 · S/N 421020N40BZHazlewood Aviation LLC · Wichita, KSBuilt 2008 · S/N 411034N40CXSchuette David A · Flemington, NJBuilt 2006 · S/N 41670N40CYGross William Patrick · Pine Bluffs, WYBuilt 2005 · S/N 41075N410TWRice Dwight L · Borger, TXBuilt 2008 · S/N 411044N411BNFranklin Kenneth A · Aliso Viejo, CABuilt 2009 · S/N 411119N411EEVaini Marc · West Plains, MOBuilt 2005 · S/N 41100N412AABagdasarian Walter DBA · El Cajon, CABuilt 2006 · S/N 41627N412PRColumbia N333xc LLC · Lewes, DEBuilt 2007 · S/N 41787N412RPHopkins Henlopen Homestead LLC · Lewes, DEBuilt 2006 · S/N 41673N415MEEonm182 LLC · El Paso, TXS/N 41505N416TBMyers Hollis Donald III · Lexington, NCBuilt 2005 · S/N 42080N422TJ422ktjde LLC · Lewes, DEBuilt 2008 · S/N 411053N424CHFlying Betty LLC · Prescott, AZBuilt 2000 · S/N 40004N426GSEmpire Crushing LLC · Wake Forest, NCBuilt 2006 · S/N 41629N427PASeigars Richard M · Port Orange, FLBuilt 2008 · S/N 411096N427TXMayfly Holdings LLC · Monticello, FLBuilt 2008 · S/N 421007N428XWillett Kyler James · Burbank, CABuilt 2008 · S/N 411076N431PCPapa Charlie LLC · Missoula, MTBuilt 2005 · S/N 41050N432JATottino David · Coachella, CABuilt 2008 · S/N 411046N43TTBluewater Islands Inc · Cape Coral, FLBuilt 2009 · S/N 411149N440TMMoeser David J · Naperville, ILBuilt 2008 · S/N 411028N441CSNorton Aviation LLC · Longboat Key, FLBuilt 2006 · S/N 41596N442SJRegistered aircraftBuilt 2006 · S/N 42521N442TAN6105s LLC · Norwood, NCS/N 41532N4446Bauermeister Aida · Ham Richmond SurrBuilt 2007 · S/N 41756N4455Sanders Russell · Canton, GAS/N 41048
Back to AD 2007-07-06 R1