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.

N537LBHttrr LLC · Austin, TXBuilt 2013 · S/N 3939N537SWBingham Leasing Co Lc · Mesa, AZBuilt 1991 · S/N TH-1619N537VBruno Airways LLC · Fayetteville, GABuilt 2004 · S/N 1009N5383ASummers Timothy P · Rincon, GABuilt 1979 · S/N 21063405N5384WFlitemax Inc · Redondo Beach, CABuilt 2004 · S/N 0854N5386ATriplett And Adams Transport Partnership LLC · New Concord, OHBuilt 1979 · S/N 21063406N538CDBertain Paul · Davis, CABuilt 2005 · S/N 1538N538NPolk Equipment Inc · Leesburg, INBuilt 2002 · S/N 0308N538SRRegistered aircraftBuilt 2007 · S/N 2502N538SYJre Management Services LLC · Ashland, VABuilt 2018 · S/N 1816N5391ASingh Amandeep · Stockton, CABuilt 1979 · S/N 21063408N5394XL K Hollenbeak Logging Inc · Hayfork, CABuilt 1980 · S/N U20605710N5395VCortez Flying Service Inc · Cortez, COBuilt 1975 · S/N 21060930N539CDAltmann Michael · Folsom, CABuilt 2004 · S/N 1127N539FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10539N539MHHolten Michael H Trustee · Maryville, ILBuilt 2026 · S/N 11402N539SRRoe Robert Darrell · Georgetown, INBuilt 2007 · S/N 2543N53AUJoachim Peter · Grafton, WIBuilt 1974 · S/N 340-0356N53CKJace Viate LLC · Tempe, AZBuilt 2013 · S/N 0442N53CRJms Transportation LLC · Leesville, LABuilt 2013 · S/N 3947N53CWBeitel Theodore C · Higden, ARBuilt 1996 · S/N 96-301024N53DHHighgate Aero Inc · Swanton, VTBuilt 2021 · S/N 5116N53KH53kwd LLC · Mason, TXBuilt 2022 · S/N 8960N53LGDominion Ventures Inc · Wilmington, DEBuilt 2014 · S/N 0812N53SHJames Robinson Homes LLC · Alpharetta, GABuilt 2021 · S/N 5008N53WMBurns Ivan · Concord, MABuilt 1999 · S/N 29-0191N53WTRock House LLC · Keizer, ORBuilt 1980 · S/N 414A0533N5401AHeadon Richard · Chino Hills, CABuilt 1979 · S/N 21063414N5401XBarbera Frank M · Edgewood, NMBuilt 1980 · S/N U20605717N5404WBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000683N5405AN5405a LLC · Beverly Hills, CABuilt 1985 · S/N P21000852N5409GRichland Aviation Inc · Sidney, MTS/N 404-0028N5409YLee Christopher · Katy, TXBuilt 1980 · S/N 21064198N540CEEverel Airborne LLC · Sandia Park, NMBuilt 1985 · S/N P21000853N540NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C0809N54105Gopub Aviation Inc Trustee · Wilmington, DEBuilt 2004 · S/N 1139N5411Mpfa Holdings LLC · Hot Springs, ARBuilt 2018 · S/N 1249N5416UU S Department Of Agriculture · College Station, TXBuilt 1984 · S/N 21064890N5416YKer Holdings LLC · Henderson, NVBuilt 1980 · S/N 21064199N54175Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1337N5417YFeldner Mark A · Schererville, INBuilt 1980 · S/N 21064200N5419WKenosha Aviation LLC · Jacksonville, FLS/N 0857N541BN907 Aviation LLC · Bend, ORBuilt 2025 · S/N 10605N541CDAcheson Wiliam B · Waconia, MNBuilt 2005 · S/N 1491N541CMAero Parts LLC · Roselle, ILS/N 340-0338N541DFSr20 Holdings LLC · Coral Springs, FLBuilt 2025 · S/N 10869N541JDBlue Sky Flyers LLC · Hoover, ALBuilt 2002 · S/N 0315N541SRSierom LLC · Charlotte, NCS/N 2109N541SWSchoorl John H · Quartz Hill, CABuilt 2006 · S/N 406N541VRStarling Investors LLC · Henderson, NVBuilt 2016 · S/N 1351
Back to AD 2012-10-13