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.

N865SSG6 Sky High Aviation Inc · Knoxville, TNBuilt 2018 · S/N 4593N865TLIsle Aviation II LLC · Osprey, FLBuilt 2023 · S/N 9637N865WBSteel South LLC · Knoxville, TNBuilt 2019 · S/N 2035N865WMDnra LLC · Missoula, MTBuilt 2023 · S/N 9216N866ADCu Flying Cirrus LLC · Woodlands, TXBuilt 2013 · S/N 0571N866CApus Aviation Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0397N866GEValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 11021N866RAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N EA-105N8671KFlight Unlimited LLC · Dover, DEBuilt 1978 · S/N 340A0611N8675KJjjp North LLC · New London, NCBuilt 1978 · S/N 340A0614N867CDMoonset Ranch LLC · Missoula, MTBuilt 2002 · S/N 0195N867CSLandpoint Aircraft LLC · Bossier City, LABuilt 2012 · S/N 0405N867LCCurd Layton · Cypress, TXBuilt 1991 · S/N E-2649N867RGKc Air Services LLC · Wilmington, DEBuilt 2009 · S/N 3376N867RMJunipero Aviators LLC · Redondo Beach, CABuilt 2025 · S/N 10790N868BRGavoha Aviation LLC · Sacramento, CABuilt 2018 · S/N 1779N868CDNational Test Pilot School · Mojave, CABuilt 2002 · S/N 0245N868CKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 3412N868LESchmidt Air LLC · Lake Mills, WIBuilt 2018 · S/N 1813N868MBrewer John Eric · Fresno, CABuilt 2021 · S/N 2276N868SRKelley Patrick Barrett · Salida, COBuilt 2007 · S/N 2860N868TWMhs Leasing LLC · Jonesboro, ARBuilt 2008 · S/N 3060N869JBJd3 Aviation LLC · Tulsa, OKBuilt 2008 · S/N 2910N869KSUniversity Of Central Missouri · Warrensburg, MOBuilt 1993 · S/N TH-1692N869MPGerhold Electric Inc · Jupiter, FLBuilt 2006 · S/N 1895N869RHRdhsr Holdings LLC · Augusta, GABuilt 2024 · S/N 10155N869SFPhoenix Rising Aviation LLC · Marlboro, NJBuilt 2026 · S/N 11382N869SMNwg LLC · Draper, UTBuilt 2007 · S/N 2596N869TFJng Aviation LLC · Hartsville, TNBuilt 2023 · S/N 9454N86AHAhydro LLC · Naples, FLBuilt 2011 · S/N 3754N86ARAlray 321 Denton LLC · Queens Village, NYBuilt 2024 · S/N 9758N86ASAerosolutions Group Inc · Wilmington, DEBuilt 2010 · S/N 0019N86AWMohave County Sheriff'S Office · Kingman, AZBuilt 1978 · S/N 414A0040N86BABelanger Aviation LLC · Foxboro, MABuilt 2025 · S/N 10874N86CDBri Mar Aviation Corp · New Britain, CTBuilt 1997 · S/N E-3145N86DHHolloway'S Tire And Auto Service Inc · Thomaston, GABuilt 1984 · S/N 21064832N86DVVallencourt Jonathan Daniel · Green Cove Springs, FLBuilt 2025 · S/N 10843N86EWLt Cirrus LLC · Southborough, MABuilt 2021 · S/N 5013N86GESierra Delta Holdings LLC · Dallas, TXBuilt 2008 · S/N 2947N86JKMartin Christopher M · Mount Vernon, OHBuilt 2003 · S/N 0525N86JWJuliet Whiskey LLC · Phoenix, AZBuilt 2016 · S/N 1435N86MESutherland Jason · Auburn, WABuilt 1999 · S/N E-3285N86MJCirrus Design Corp · Duluth, MNBuilt 2010 · S/N 3711N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533N86NXQuinn Dana S Trustee · East Harwich, MABuilt 2002 · S/N 0236N86PDTanric Aviation LLC · Tuscola, TXBuilt 1982 · S/N 414A0837N86VSPlotkin Aviation LLC · Boca Raton, FLS/N 414-0955N86WBHarris Michael G · New Orleans, LABuilt 2004 · S/N 1173N8702KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0623N8707KDelaware Corp · Topping, VAS/N 340A0982
Back to AD 2012-10-13