OpenAirDocs.org
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.

N17040Prather Carl L · Gilroy, CABuilt 1976 · S/N 240N170DLRlw 767 LLC · Lighthouse Point, FLBuilt 2006 · S/N 2017N170EJZirkel Acquisition Corp LLC · Colchester, VTBuilt 2010 · S/N 3604N170SGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2014 · S/N 4122N170SRSj Airways LLC · Wilmington, DEBuilt 2007 · S/N 2456N17113J&L Aviation LLC · Lakewood Ranch, FLBuilt 2012 · S/N 3851N1713HGay James · Rochester, MNBuilt 2014 · S/N 0944N1716EMccaskill William L · Hampton, VABuilt 1978 · S/N 310R1547N1717SXp Silva Air LLC · Rockaway, NJS/N TJ-53N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155N171FRSilver Fox Aviation LLC · Milstone, NJBuilt 2026 · S/N 11212N171HTChico Gregory John · Dayton, NVBuilt 2005 · S/N 1613N171HZLt Aviation LLC · Downers Grove, ILBuilt 2019 · S/N 2022N171MAChute First LLC · Covina, CABuilt 2005 · S/N 1398N171MFSchwartz Bernard · Las Vegas, NVBuilt 2006 · S/N L2K-215N171PBHarding Derrick S DBA · Adair, OKBuilt 1995 · S/N E2992N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558N171SRRegistered aircraftS/N 2422N171TBMaritime Aviation Security Team · Wilmington, NCBuilt 2002 · S/N 40045N171TDFh Consulting LLC · Christiana, TNBuilt 2020 · S/N 4973N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894N171TSWindow Universe LLC · Beaverton, ORBuilt 2008 · S/N 2900N171TXMigliorini Alexander P · Eureka, CABuilt 2011 · S/N 0203N171VTShly Aviation LLC · Carnegie, PABuilt 2002 · S/N 0142N1721Qualitair LLC Trustee · MichelstadtBuilt 1993 · S/N E-2783N1724XN2200b LLC · Cicero, NYBuilt 2014 · S/N 4090N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735N173CBAircraft Associates LLC · Valparaiso, INBuilt 2006 · S/N 1877N173CKKali Equipment 2 LLC · Burlingame, CABuilt 2018 · S/N 1727N173KHD & B Management LLC · Clayton, GABuilt 2004 · S/N 1191N173KTCrawford Chris M · North Dinwiddie, VAS/N 40035N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960N173SRRomeo Pappa LLC · Midlothian, TXBuilt 2006 · S/N 1925N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763N174DLHubbard James E · Bessemer, MIBuilt 2007 · S/N 2437N174DSSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 414A0216N174MHMartins Aviation LLC · London, KYBuilt 2023 · S/N 9038N174MPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11519N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174N174SKSaltt Air LLC · Oakland, MDBuilt 2018 · S/N 1741N174YMSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2010 · S/N 3644N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358N175DSSkyfall Aviation LLC · Maryville, TNBuilt 2024 · S/N 10257N175DYFirst Tracks Aviation LLC · Lewes, DEBuilt 2010 · S/N 3608
Back to AD 2012-10-13