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.

N214CTValiair Limited Co Trustee · Casper, WYBuilt 2009 · S/N 3584N214DAFlight International Inc Trustee · Dover, DEBuilt 1999 · S/N 29-0181N214DJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0746N214DKJohnson Matthew Alfred · Moorhead, MNS/N LIV-416N214JGValiair Lc Trustee · Casper, WYS/N 2048N214JSChavez Frederick J · Temecula, CABuilt 1997 · S/N 29-0128N214KPBnb Aviation LLC · Chesterfield, MOBuilt 1999 · S/N TH-1894N214MKoo C Carlos · Atherton, CABuilt 1985 · S/N P210-00863N214MWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2014 · S/N 0840N214RJJones Larry V · Ocala, FLBuilt 1999 · S/N E3263N214TWRegistered aircraftBuilt 2004 · S/N 1225N214TXAdams Randy K · Spicewood, TXBuilt 2014 · S/N 4066N214VQSimply Living LLC · Fort Myers, FLBuilt 2011 · S/N 3808N214WFWathen Aviation Inc · Hilliard, OHBuilt 2014 · S/N 0918N214ZARegistered aircraftBuilt 2016 · S/N 1338N2150XCascade Airplanes Inc · Visalia, CABuilt 1999 · S/N 30-0036N21530Graham Douglas E · Matthews, NCBuilt 1999 · S/N 30-0030N2153KCaf Design LLC · Wilmington, DES/N 29-0115N2153ROrton Sterling · Cedar City, UTS/N EA-540N2155ECavu Aviation LLC · Sugar Grove, ILBuilt 1998 · S/N 29-0165N2155KCurrent Obsession LLC · Gaylord, MIBuilt 1998 · S/N 29-0164N2155NFlight Test Affiliates LLC · Flagler Beach, FLBuilt 1981 · S/N EA-255N2158JMccormick Eugene C DBA · Tyler, ALBuilt 1979 · S/N T18803395TN2158N2th Aviation LLC · Johnson City, TNBuilt 1998 · S/N 29-0167N2159ER & S Investment Partners LLC · Kennesaw, GABuilt 2000 · S/N 29-0238N215AEN215ae LLC · Dover, DEBuilt 2026 · S/N 11463N215ALUdaan LLC · Vienna, VABuilt 2025 · S/N 11061N215CBKw Bradley Associates LLC · Manlius, NYBuilt 1980 · S/N 340A1019N215EBSalty Air LLC · Wayne, PABuilt 2024 · S/N 9766N215EMPostma Air LLC · Saint Paul, MNS/N 2453N215FJOzark Machinery Transportation LLC · West Plains, MOBuilt 2018 · S/N 1742N215GNBbt Jewelry LLC · Miami, FLS/N P21000335N215GPPoint To Point LLC · Missoula, MTBuilt 2012 · S/N 0331N215JGClower Aviation LLC · Owasso, OKBuilt 2013 · S/N 0486N215JPPilot Peak Adventures LLC · Ely, NVBuilt 2007 · S/N 2493N215LLNorthern Colorado Capital Holdings LLC · Timnath, COBuilt 2010 · S/N LS227N215NCDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N E-3444N215RRRednor Jeffrey · Yardley, PABuilt 2005 · S/N 1448N215RWUnderwood Darin M · Cedar Rapids, IABuilt 1995 · S/N E-2965N215TTEcho Whiskey Charlie LLC · Midland, TXBuilt 2013 · S/N 0458N21612Newbury Kirsten · Lake Oswego, ORS/N 30-0045N2161SRegistration Pending · Montezuma, NMRegistration pendingBuilt 1998 · S/N 290137N21625Simpson Aaron J · Fort Smith, ARBuilt 1998 · S/N 29-0170N21632Skyking 60 LLC · Tampa, FLBuilt 1999 · S/N 30-0006N2164KSamojen Tony J · Camarillo, CABuilt 1998 · S/N 29-0172N2165NCronstadt Adams Inc Trustee · Wilmington, DEBuilt 1999 · S/N 30-0007N216691432 Prince Street LLC · Eden, TXBuilt 1999 · S/N 30-0008N2166TParadise Aviation LLC · Valrico, FLBuilt 1999 · S/N 30-0011N2169WN2169w LLC · Golden, COBuilt 1999 · S/N 30-0019N216BDBoldmethod Air LLC · Boulder, COBuilt 2017 · S/N 1550
Back to AD 2012-10-13