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.

N98AFScales James O Trustee · Newburgh, INBuilt 1999 · S/N ES-047FBN98ATEkim Builders Inc · San Diego, CABuilt 2024 · S/N 10345N98BKThomas W Wilkinson Cpa Pllc · Austin, TXS/N 3527N98CEQueen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 414A0066N98HHLittle Wing LLC · Block Island, RIBuilt 2006 · S/N 2260N98HMRegistered aircraftS/N 97-301025N98JKIntagliata Joseph V · Hanna, INBuilt 1998 · S/N EA-609N98LRZ Corp Inc · Middletown, DEBuilt 1997 · S/N E-3126N98LWConstruction Equipment Manufacturing Co Inc · Olney, TXBuilt 2009 · S/N 3428N98MMSrt Group Inc · Southaven, MSBuilt 1979 · S/N 340A0639N98RCPegasus LLC · Farmington, NMBuilt 1973 · S/N 340-0187N98RETwin Star Hot Springs LLC · Hot Springs, ARBuilt 1977 · S/N TJ-108N98RFDabosa LLC · Bernville, PABuilt 2003 · S/N 0520N98SDMjbk Adventures LLC · Monrovia, INBuilt 1980 · S/N 310R1872N98SLKm Ventures LLC · Waltham, MABuilt 2019 · S/N 4868N98THTar Heel Air LLC · Wilmington, DEBuilt 2025 · S/N 10763N98TN527 Logistics Inc · Knoxville, TNBuilt 2023 · S/N 9526N98TTGo Plane Go LLC · Davenport, WABuilt 2018 · S/N 1802N98UMRpa Aero LLC · Riverton, UTBuilt 2019 · S/N 2010N98VCVictor Adventures LLC · Ottawa, OHBuilt 1998 · S/N E-3170N98WENorthern Aviation LLC · Roberts, MTBuilt 1997 · S/N E-3146N990Dl Industries Inc · Claremont, NHBuilt 2025 · S/N 10997N990BSYanish Ronald L · Goodland, FLBuilt 2004 · S/N 1061N990CDWertsberger Shalom · Rochester, NYBuilt 2004 · S/N 1087N990JBMurphy George E · Robinson, ILBuilt 1977 · S/N 340A0370N990MCSidestick LLC · Mckinney, TXBuilt 2022 · S/N 8639N990MDMelchiorre Joseph G · Lewes, DEBuilt 1964 · S/N D-7527N990PValli Air LLC · Leonardtown, MDBuilt 2004 · S/N 0945N990PCCmm Enterprises LLC · Pharr, TXBuilt 1974 · S/N 414-0546N990PTMiller High Life Aviation LLC · Charleston, SCBuilt 2023 · S/N 9624N9915DEvery Time Aviation LLC · Lake Havasu City, AZS/N 29-0090N991AAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0317N991EWLand Baron Wings LLC · Billings, MTBuilt 2017 · S/N 1481N991FPR&R Aces LLC · Bentonville, ARBuilt 2006 · S/N 2155N991MZNelson Tyler · Napa, CABuilt 2016 · S/N 1355N991PCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2012 · S/N 0311N991PMSandy Herd LLC · Amarillo, TXBuilt 2005 · S/N 1601N991SBIdec Flyer LLC · Rancho Santa Fe, CABuilt 2010 · S/N 0059N991SGEnjoy The Journey LLC · Chandler, AZBuilt 2022 · S/N 8983N9922TInfoobjects Inc · Saratoga, CABuilt 2026 · S/N 11386N9922YInfinite Wings LLC · Henderson, NVBuilt 1982 · S/N 21064640N9923YPostupack Peter Jr · New Cumberland, PABuilt 1982 · S/N 21064641N9923ZChena River Aviation Inc · Fairbanks, AKBuilt 1983 · S/N U20606747N9928FWatermaster Irrigation Supply Inc · Lubbock, TXBuilt 1972 · S/N 340-0165N9928YEckelkamp L B Jr · Washington, MOBuilt 1982 · S/N 21064643N992CBaker Clark D · Great Bend, KSS/N L2K-312N992DMCarolina Creative Leasing LLC · Easley, SCBuilt 2021 · S/N 2306N992KN992k LLC · Napa, CABuilt 2005 · S/N 1600N992LKIcc Aviation LLC · Belleville, MIBuilt 2003 · S/N 0610N992MBob Blandford Air LLC · Saint Johns, FLBuilt 2021 · S/N 5049
Back to AD 2012-10-13