AD 2005-10-13

Registered aircraft · 1,224

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:2005-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13')
  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.

N480VCSn5084 Inc Trustee · Wilmington, DEBuilt 2005 · S/N 5084N481RDSchwam Julie R · Hayden, IDS/N 6716N482MHDrd Aviation LLC · Park City, UTBuilt 2005 · S/N 5086N483RVan Horn Aviation LLC · Tempe, AZBuilt 1969 · S/N 483N483SHSharkeys Helicopter Inc · West Lebanon, NHBuilt 2016 · S/N 5236N484MHNew Course Aviation Co · Golden, COBuilt 2005 · S/N 5085N48552Brown Helicopter Inc · Pensacola, FLBuilt 2001 · S/N 5275N487ALRedding Air Service Inc · Redding, CABuilt 1997 · S/N 53150N488BCButte County Sheriffs Office · Oroville, CABuilt 1993 · S/N 5103N48FSOwen Jay · Wolf Creek, MTBuilt 2006 · S/N 5091N48HHVarney Aviation LLC · Bangor, MEBuilt 1982 · S/N 3620N48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137DN48NEnstrom Helicopter Corp · Menominee, MIBuilt 2023 · S/N 5255N490WMSouth Florida Water Management District · West Palm Beach, FLBuilt 2008 · S/N 4652N493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321N49589North Wind Aviation LLC · Chelan, WABuilt 1976 · S/N 1912N499KCopper River Airmotive LLC · Copper Center, AKBuilt 1980 · S/N 20700632N499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448DN499WMAgricultural Air Services LLC · Jupiter, FLS/N 4376N49BBGiuseppe Baldassarri · Carrollton, GABuilt 1985 · S/N 037N49TJShoreline Aircraft Leasing LLC · Lewes, DEBuilt 1975 · S/N 550747SN49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006DN5008KL&R Investment Partners LLC · Wilmington, DES/N 2524N500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456DN500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610DN500EVSnohomish County Sheriff · Snohomish, WABuilt 1989 · S/N 0340EN500FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1983 · S/N 0442EN500HJ392e Inc Trustee · Wilmington, DEBuilt 1990 · S/N 0392EN500KYRotor Imaging LLC · Reading, PABuilt 1989 · S/N 0345EN500LKWinco Inc · Aurora, ORBuilt 1983 · S/N 0009EN500MUHva Inc · Summersville, WVBuilt 1996 · S/N 0533EN500MVTreeline Helicopters Inc · Bristol, TNBuilt 1977 · S/N 770156DN500NCSanders Associates LLC · Bluefield, VABuilt 1977 · S/N 1260052DN500NRAycd LLC · Allentown, PABuilt 1983 · S/N 3049N500RTCessna 210 LLC · Waynesville, MOBuilt 1976 · S/N 1050773SN500SLPatriot Marine LLC · New Haven, CTBuilt 1988 · S/N 0309EN500SYNalas Inc Trustee · Wilmington, DEBuilt 1983 · S/N 0007EN500TNOnespan Powerline Services LLC · Peachtree City, GABuilt 1979 · S/N 590521DN500TYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 0086EN500TZGulf Helicopters LLC · Santa Fe, TXBuilt 1979 · S/N 590507DN500USYarak Aviation LLC · Big Timber, MTBuilt 1973 · S/N 986N500VSVertol Systems Company Inc · Destin, FLBuilt 1977 · S/N 170072DN500WXTre Aviation Corp · Wilmington, DEBuilt 1992 · S/N 0493EN500XVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 1200881DN5010PMarkov Michael J · Oceanside, CABuilt 1978 · S/N 2573N50141Greenwood Helicopters Inc · Washington, NCBuilt 1979 · S/N 2603N501JSShelby County Sheriffs Office · Columbiana, ALBuilt 1995 · S/N 5195N501MDAgricultural Air Services LLC · Jupiter, FLBuilt 1991 · S/N 0485EN501RMCity Of Pasadena · Pasadena, CABuilt 2009 · S/N 0598EN501TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 2592
Back to AD 2005-10-13