AD 2012-10-13

Registered aircraft · 13,306

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:2012-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:2012-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.

N685DMMetcalf Steven · West Union, IABuilt 2002 · S/N 0322N685SRRegistration Pending · Seattle, WARegistration pendingBuilt 2007 · S/N 2586N685TLSeefeeltrust LLC · Gypsum, COBuilt 2015 · S/N 0970N6867CHelms Foodservice Inc · Lake City, FLBuilt 1980 · S/N 335-0061N6869LWeatherby Joseph III Trustee · Cuyahoga Falls, OHBuilt 2000 · S/N 29-0229N6869RPro Air Media LLC · Sevierville, TNBuilt 2006 · S/N 2121N686DSScheigert Delbert F Jr · Saint Cloud, FLBuilt 2006 · S/N 1957N686JPJp Aviation LLC · Atlanta, GABuilt 2025 · S/N 10779N68707Ascp Blue Skies LLC · Columbia, MOS/N 340A1515N6870MApplied Science Services Corp · Woodland Hills, CABuilt 1977 · S/N 21061998N68717Horst Paul A · Clarkrange, TNBuilt 1982 · S/N 340A1526N6871DPickett Aviation LLC · Brownsboro, ALBuilt 1982 · S/N 340A1519N68752Hyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0518N6875DHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0511N6879RHyannis Air Service Inc · Hyannis, MAS/N 402C0611N687CWUniversity Lakes Property LLC · Miami, FLBuilt 2021 · S/N 2257N687PWDragonflier LLC · Las Vegas, NVBuilt 2020 · S/N 4923N687SAGerstein Lee · Park City, UTBuilt 2001 · S/N EA-687N687WTCharlie Delta Group LLC · Bismarck, NDBuilt 2014 · S/N 0958N688CJtc Properties LLC · Carmel, CABuilt 2023 · S/N 9306N688ERWolf Kenneth P · Orange Park, FLBuilt 2014 · S/N 0745N688LDRoper Technologies Inc · Sarasota, FLBuilt 2017 · S/N 1539N688PDUnusual Attitudes LLC · Bates City, MOBuilt 2007 · S/N 2398N688SPSanchez Eddy B · Miami Gardens, FLS/N 402B0603N688SRRsm Enterprises LLC · Helena, MTBuilt 2007 · S/N 2826N6899BCowgill Robert W · Amissville, VABuilt 1978 · S/N 21062852N689CAir Mt A36 LLC · Lake Havasu City, AZBuilt 2002 · S/N E-3461N68AWTas Aircraft Sales LLC · Troutdale, ORS/N 0319N68BARegistered aircraftBuilt 2017 · S/N 4585N68BMDavenport Donald · North Las Vegas, NVBuilt 1977 · S/N 21062441N68DXFreeman David J · Seattle, WABuilt 2002 · S/N 0214N68EAPav East LLC · Camden, DEBuilt 1985 · S/N P21000837N68FRManz Aviation Services LLC · West Reading, PABuilt 2019 · S/N 1977N68GTBoon Hong Sim · New York, NYBuilt 2009 · S/N 3596N68GYOwll Aviation LLC · Baton Rouge, LABuilt 2016 · S/N 4364N68JFAjs Aviation LLC · Warroad, MNS/N U20606728N68JWBobcat Aviation LLC · South Hutchinson, KSBuilt 1978 · S/N 340A0500N68KLVoloshin Vitaly · Seattle, WABuilt 1977 · S/N 340A0258N68MGDreger Dean R · Wilbur, WABuilt 1981 · S/N 21064392N68MMLetters Inc · Santa Maria, CABuilt 1979 · S/N EA-5N68NQRounds Dana H · Vacaville, CABuilt 1976 · S/N U20603399N68PFWooden Steve S Trustee · Nokomis, FLBuilt 2013 · S/N 4021N68SYFreeman William M · Cameron Park, CABuilt 2004 · S/N 0930N68TBSmith Ronald A · Los Gatos, CABuilt 1981 · S/N 21064492N68WBFloatron Inc · Phoenix, AZBuilt 2003 · S/N LIV-341N68WTFront Range Cirrus LLC · Denver, COBuilt 2017 · S/N 1649N6900XMueller Robert C · Reno, NVBuilt 1977 · S/N 21062392N6908PSix Six Hotel Corporation · Bangor, PABuilt 1985 · S/N 46-8508062N6908XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508064N690NDAltitude Adjustment LLC · Lisle, ILBuilt 2006 · S/N 1851
Back to AD 2012-10-13