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.

N226SRDairyaire LLC · Brookfield, WIBuilt 2023 · S/N 9179N226TWBb Aviation LLC · Louisville, KYBuilt 2019 · S/N 4837N226TXGriffin Christopher W · Blowing Rock, NCBuilt 2009 · S/N 3390N226XYTar Aviation LLC · Akron, IABuilt 2003 · S/N 0486N2271LBurchinal Skyler · Brookston, TXS/N TJ-71N2275CCrusader Medical Consulting LLC · Boonville, INBuilt 1982 · S/N T30300085N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945N2277CC4 Holdings Group LLC · Odessa, FLBuilt 2026 · S/N 11434N227BDBlack Dog Aviation LLC · Avon, MNBuilt 2008 · S/N 3134N227BRSchoo Michael J Trustee · Ridgway, COBuilt 1977 · S/N TK-31N227CELynco Electric Co Inc · Las Cruces, NMBuilt 2023 · S/N 9618N227CLCirrus Sr22t 2180 Inc Trustee · Wilmington, DEBuilt 2020 · S/N 2180N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540N227DHFirst Sierra Insurance Services LLC · Fresno, CABuilt 2023 · S/N 9308N227DZAd Holdings Group Inc · Wilmington, DEBuilt 2008 · S/N 3288N227ESHkr Aero LLC · Chattanooga, TNBuilt 2023 · S/N 9201N227FDSpettro Air LLC · Monroe, LABuilt 2023 · S/N 9113N227GEAero Mobil Inc · Wilmington, DEBuilt 2022 · S/N 8595N227GWMercatoair LLC · Newark, DEBuilt 2026 · S/N 11132N227HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 3438N227HWFirst Avenue Aviation LLC · Mountain Brk, ALBuilt 2022 · S/N 8892N227JHRgs Aviation LLC · Lexington, KYBuilt 2015 · S/N 4237N227KCSeven Kilo Charlie LLC · Lawrence, KSBuilt 2021 · S/N 5012N227MMThf Aviation II LLC · Naples, FLBuilt 2023 · S/N 9326N227MPGo Raleigh Aviation LLC · Cary, NCBuilt 2014 · S/N 4141N227MXValiair Limited Co Trustee · Casper, WYBuilt 2024 · S/N 9954N227PGDiederich Drone Service LLC · Fargo, NDBuilt 2010 · S/N 3675N227RTBarnard David W · La Follette, TNBuilt 2007 · S/N 2357N227SMIpme Management Corp · Jefferson, GABuilt 2004 · S/N 41011N227SPIowa State Patrol · Des Moines, IABuilt 2021 · S/N 5050N227SSRiver Front Akn LLC · Anchorage, AKBuilt 1970 · S/N U20601516N227WBSlamo LLC · Bulverde, TXBuilt 2017 · S/N 4523N2288DTen Equipment LLC · Boston, MABuilt 2011 · S/N 3761N2289ERegistered aircraftBuilt 1997 · S/N TH-1821N228ABLuke Stephen J Trustee · Middleboro, MABuilt 1991 · S/N E-2655N228CFAsterix Aviation Inc · New York, NYBuilt 2021 · S/N 5007N228DFKv Wines Inc · Calistoga, CABuilt 2012 · S/N 0282N228DLW3 Aviation LLC · Decatur, TXBuilt 2023 · S/N 9042N228DMStone Michael · Payson, AZBuilt 1991 · S/N E-2660N228DWSalty Bleuwater Fishing LLC · New Smyrna Beach, FLBuilt 2019 · S/N 2027N228EEYankee Alpha LLC · Columbia, MDBuilt 2019 · S/N 1979N228FD228 Properties LLC · Tabernacle, NJBuilt 2023 · S/N 9115N228KTTattersall Thomas K · Richmond, VABuilt 2021 · S/N 2301N228LRPatrose LLC · Stateline, NVBuilt 2025 · S/N 11090N228MMFly Enterprises LLC · Cumberland, WIBuilt 2005 · S/N 1335N228RPJonesboro Cycle And Atv LLC · Bone, ARBuilt 2021 · S/N 2287N228RSRkg Enterprises · Hibbing, MNBuilt 2014 · S/N 0707N228TLSaltt Air LLC · Oakland, MDBuilt 2018 · S/N 1666N228TTT2 Contracting Inc · Fuquay Varina, NCBuilt 2023 · S/N 9314N228ZFlying Nacho Aviation LLC · Draper, UTBuilt 2021 · S/N 2241
Back to AD 2012-10-13