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.

N42AMGruhlkey William H · Wildorado, TXBuilt 1979 · S/N EA-29N42BDKristoferson John S · Denton, TXBuilt 1988 · S/N 4608122N42BELasalle Management Company LLC · Ruston, LAS/N 3903N42BWHci Real Estate II LLC · Granbury, TXBuilt 2022 · S/N 8754N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228N42ESTree Tangos LLC · Nashville, TNBuilt 2019 · S/N 1985N42KWMarine Aviation LLC · Lyme, NHBuilt 2001 · S/N TH-1985N42LCFly To Ski LLC · Avalon, NJBuilt 2025 · S/N 10684N42MDN42md LLC · Ashburn, VABuilt 1999 · S/N 29-0178N42MWWalker Winston W Trustee · Tucson, AZBuilt 1981 · S/N 414A0680N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387N42PYArtemis Aviation LLC · Houston, TXBuilt 2022 · S/N 8941N42QAAvisaga LLC · San Jose, CABuilt 2023 · S/N 9598N42SGPolar Star Co · Wilmington, DES/N 4140927N42SHLejoran LLC · San Mateo, CABuilt 2024 · S/N 10066N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109N42TBFlores Nicholas L Jr · San Antonio, TXBuilt 1998 · S/N TH-1872N42TJShark Vision LLC · Palm Harbor, FLBuilt 2017 · S/N 4507N42TNCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11521N42TVK2 Aviation LLC · Carroll, IABuilt 1998 · S/N 29-0168N42TXWu Tang Aviation LLC · Queen Creek, AZBuilt 2012 · S/N 0297N42VXJjl Aviation LLC · Springville, IABuilt 2022 · S/N 9025N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667N42ZBMelbourne Aviation LLC · Melbourne Beach, FLBuilt 2016 · S/N 1449N42ZNHuntsville Flyers LLC · Owens Cross Roads, ALBuilt 2001 · S/N 0042N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011N4305UMarshall Paul A Trustee · Gilroy, CABuilt 2000 · S/N E-3305N4306WBlaylock Christopher W · Lubbock, TXBuilt 2000 · S/N E-3352N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183N430BCInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1N430BJBuena Vista Aviation LLC · Mantua, NJBuilt 2023 · S/N 9374N430FMCygnus Inc · Sioux Falls, SDBuilt 2000 · S/N E-3319N430LPDiamond D Aviation LLC · Northford, CTBuilt 2017 · S/N 4454N430MW1st Avenue Lrt Cirrus LLC · San Diego, CAFirst renewal noticeBuilt 2014 · S/N 0880N430PDTll Holdings Inc · Cornelius, NCBuilt 2022 · S/N 8867N4312VBaron Be 58 LLC · Essex, MTBuilt 1984 · S/N 46-8408012N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532N4319MSale Reported · Aptos, CASale reportedBuilt 1983 · S/N 46-8408005N431CDMother Of Perpetual Succor LLC · Villa Hills, KYBuilt 2005 · S/N 1501N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431N431DBDuininck Companies LLC · Prinsburg, MNBuilt 2003 · S/N 29-0288N431PCPapa Charlie LLC · Missoula, MTBuilt 2005 · S/N 41050N431PDNon-Stop LLC · Kirkland, WABuilt 2024 · S/N 9803N4323BBkt Holdings LLC · Mont Belvieu, TXBuilt 1983 · S/N 46-8408009N4323POverspray LLC · Norfolk, NEBuilt 1983 · S/N 46-8408013N4324VTriple Aaa LLC · Garden City, KSBuilt 2001 · S/N TH-2014N4326CSeven Echo Whiskey Corp · Wilmington, DEBuilt 1976 · S/N 340A0075N432CBAlltrade Aviation LLC · Fort Branch, INBuilt 2004 · S/N 1175N432CDVlahos Aviation LLC · Destin, FLBuilt 2004 · S/N 0941N432CEFreedom Equipment Inc · Lake Havasu City, AZBuilt 2022 · S/N 8792
Back to AD 2012-10-13