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.

N6500GConsultant Services LLC · Stillwater, MNBuilt 2004 · S/N 42045N6500LApsis Aviation LLC · Kentfield, CABuilt 2001 · S/N 40027N6500VBlue Marble Aviation LLC · Center Valley, PABuilt 2003 · S/N 42033N6501MByrne William J · Davis, CABuilt 2001 · S/N 40023N6501UMoses Hunter K · Georgetown, TXBuilt 2004 · S/N 42040N6501ZJ&M Aviation Enterprises LLC · Greendale, WIBuilt 2003 · S/N 42007N65029Woodberry Robert A · Mineral, VABuilt 2004 · S/N 41024N6502ABelair Two LLC · Lancaster, PABuilt 2004 · S/N 42048N6502HSimpson Equipment Leasing LLC · Hays, KSBuilt 2004 · S/N 42037N6502XFalcon Way Partners LLC · East Helena, MTBuilt 2004 · S/N 42039N65031Miller Lewis W · Setauket, NYBuilt 2004 · S/N 42060N65035Vimco Aviation LLC · El Paso, TXBuilt 2004 · S/N 42052N6503CPotts Phillip G · Chattanooga, TNBuilt 2003 · S/N 42015N6503TRussell Construction Co · Douglas, WYBuilt 2002 · S/N 40039N65042Blueventure LLC · Morganton, NCBuilt 2004 · S/N 42042N6504DAirmart Aircraft Holdings Inc · Oak Ridge, NCS/N 42035N6504HPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 41010N6504KQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 40062N6504XMarc Pauls · Charlotte, NCBuilt 2004 · S/N 42056N6504ZAlbertson Robbie H · Easley, SCBuilt 2003 · S/N 42024N6505CLancair Leasing LLC · Greensboro, NCBuilt 2003 · S/N 40066N6505LTheriot Conchita F · Anderson, SCBuilt 2001 · S/N 40033N6505VElg Air LLC · Birmingham, ALS/N 42053N6505ZJames Bryan C · Fredericksburg, TXBuilt 2004 · S/N 42044N6507YJudge Allen · Lebanon, ILBuilt 2004 · S/N 41008N6508ALynch John Z · Elon, NCBuilt 2004 · S/N 42038N6508BTechnology Farm Inc · Tewksbury, MABuilt 2002 · S/N 40053N6508FDi Ioia Mickey · Glen Mills, PABuilt 2004 · S/N 42061N65099Aguirre-Y-Luker Grant C · Santa Fe, NMBuilt 2003 · S/N 40075N6509AStockard Ryan · Abilene, TXBuilt 2004 · S/N 41006N6509YColumbia 400 LLC · Reno, NVBuilt 2004 · S/N 41009N6509ZQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 42020N65105Hall Herb · Leawood, KSBuilt 2004 · S/N 42059N6510V1903 Aviation LLC · Saint Augustine, FLS/N 42029N6510YSaginaw LLC · Missoula, MTBuilt 2004 · S/N 42057N6511YToys LLC · Cumberland, RIBuilt 2003 · S/N 40073N65123Martin Michael · Galesburg, ILS/N 40077N6512FFunk Norman J · Norfolk, NEBuilt 2003 · S/N 40078N6512RCeresa Glen · Watsonville, CABuilt 2003 · S/N 42014N6512ZNuvo Concepts Corp · El Paso, TXBuilt 2003 · S/N 42017N65131Bas Part Sales LLC · Greeley, COBuilt 2003 · S/N 42027N6513GMarno Aviation LLC · El Paso, TXBuilt 2003 · S/N 42025N6514BN2828 LLC · Highland, WIBuilt 2001 · S/N 40026N660BAAlbright Anthony F · Covington, LABuilt 2008 · S/N 411056N661WBGratsinger Scott · Hillsboro, ORBuilt 2005 · S/N 41067N666ASPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 41636N667AFRemontar LLC · Midland, TXBuilt 2008 · S/N 411080N66NSRecker Rodney Thomas · Redding, CABuilt 2009 · S/N 411122N671SMRegistered aircraftBuilt 2005 · S/N 41066N678YYVan Bortel Aircraft Inc · Arlington, TXS/N 41798
Back to AD 2007-07-06 R1