OpenAirDocs.org
AD 2006-04-13 R1

Registered aircraft · 671

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:2006-04-13-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:2006-04-13-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.

N75RPTransportation Holdings III LLC · Dallas, TXBuilt 2014 · S/N 5460N75TFBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 5333N765ATSapphire No5 LLC · Westlake Village, CABuilt 2004 · S/N 5063N767CHAi5278 LLC · Southlake, TXBuilt 2010 · S/N 5278N768JJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 5217N769WECd 321 LLC · Austin, TXBuilt 2004 · S/N 5048N76THBellevue N76th LLC · North Kingstown, RIBuilt 2007 · S/N 4071N76VZRegistered aircraftBuilt 2020 · S/N 5623N771LN157bc LLC · Winnetka, ILBuilt 2005 · S/N 4033N772BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5582N773LMAlko 250 LLC · San Francisco, CABuilt 2014 · S/N 4311N776BTHilltop Asset Holdings LLC · Saratoga Springs, NYBuilt 2009 · S/N 4170N777KLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5421N777YJBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5403N778CRCmr LLC · Chicago, ILBuilt 2006 · S/N 4056N779AZPittco Aviation LLC · Memphis, TNBuilt 2007 · S/N 4089N780CRCmr III LLC · Chicago, ILBuilt 2019 · S/N 5594N780EAkfl3 LLC · Farmingdale, NYBuilt 2009 · S/N 5258N780KSMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2005 · S/N 5091N785QSSavannah Belle LLC · Santa Cruz, CABuilt 2007 · S/N 5157N787JSRegistered aircraftBuilt 2010 · S/N 4189N789LRNordlys LLC · Bedford, NHBuilt 2006 · S/N 5100N790DCDynamic Healthcare Solutions DBA · Dallas, TXBuilt 2007 · S/N 4070N793MGHaupt LLC · Jupiter, FLBuilt 2009 · S/N 5263N795CRTime 2 Fly 2.0 LLC · Richmond, VABuilt 2014 · S/N 5474N795SPLockton Enterprises Inc · Kansas City, MOBuilt 2013 · S/N 5448N799SPPnc Bank National Association · Boise, IDBuilt 2017 · S/N 5568N7RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4017N7SESteven Brothers Aviation LLC · Wichita, KSBuilt 2005 · S/N 5088N800JHJ&J Aviation LLC · Crested Butte, COBuilt 2005 · S/N 5073N801ASRegistered aircraftBuilt 2005 · S/N 5097N803AGTextile Aviation LLC · Dalton, GABuilt 2010 · S/N 4194N803TMTai Leasing Inc · Mckinney, TXBuilt 2008 · S/N 5226N809DATrt Equity Advisors LLC · Dallas, TXBuilt 2010 · S/N 5269N80ADArcadia Leasing LLC · Arcadia, WIBuilt 2016 · S/N 5539N810BRegistered aircraftBuilt 2014 · S/N 5479N812RBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5045N813QSBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 5160N814PRRegistered aircraftBuilt 2006 · S/N 5117N815GYDry Fly Aviation LLC · San Francisco, CABuilt 2008 · S/N 5202N816RZRed Zeppelin LLC · Boerne, TXBuilt 2013 · S/N 5432N817AFArcadia Leasing LLC · Arcadia, WIBuilt 2016 · S/N 4352N817DEDouble Eagle Aviation LLC · Fort Worth, TXBuilt 2012 · S/N 4253N818BKAir Maui LLC · Oakland, CABuilt 2006 · S/N 4047N818CJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5430N819SSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5573N81GKRegistered aircraftBuilt 2011 · S/N 4225N820RKJrock LLC · New York, NYBuilt 2012 · S/N 5392N821CNNoble Legacy Leasing LLC · Newark, DEBuilt 2007 · S/N 4085N8228NAnnero LLC · Los Angeles, CABuilt 2004 · S/N 5057
Back to AD 2006-04-13 R1