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.

N22TYCygnus9 LLC · Fayetteville, NCBuilt 1997 · S/N TH-1826N22USN22us LLC · Newberg, ORBuilt 2022 · S/N 8692N22VCVictorcharlie LLC · Weston, MABuilt 2005 · S/N 1341N22VFAir Conejos LLC · El Paso, TXBuilt 1978 · S/N P21000106N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171N22WBHemingway Aviation LLC · Palm Beach Gardens, FLBuilt 2024 · S/N 10314N22WEWings Over Saluda Institute LLC · Wilmington, DEBuilt 2022 · S/N 9023N22WGCorpat Inc · Missoula, MTBuilt 1981 · S/N P21000733N22WXCisneros Corina · Belmont, NHBuilt 2002 · S/N 0281N22XDNokes James · Woodbury, TNBuilt 2003 · S/N 0531N22XJSmile Air LLC · Vidalia, GABuilt 2012 · S/N 3835N22YYArjad Henry · Irvine, CABuilt 2003 · S/N L2K-144N22ZFEastern Stearman Inc Trustee · Leesburg, VABuilt 2006 · S/N 1902N22ZMAbkw Air Sunshine LLC · Wilmington, DEBuilt 2007 · S/N 2684N2302CDuck & Goose Aviation Inc · St Simons Island, GABuilt 1997 · S/N E-3102N2303VFindlay Fly Boys LLC · Findlay, OHBuilt 1998 · S/N E-3168N2306DUS Navy - Owner · Jacksonville, FLBuilt 1979 · S/N 21063828N2307CStuffmann Eric S · Orinda, CABuilt 1997 · S/N E-3107N2307JMidwest Kilo Delta LLC · Clara City, MNBuilt 1997 · S/N EA-607N230CARinehart Investment Group LLC · Forest Lake, MNBuilt 2011 · S/N 3821N230SRNational Auto Solutions LLC · Gallatin, TNBuilt 2007 · S/N 2361N230SX2z West LLC · Alpine, WYBuilt 2004 · S/N 41045N230VFVictor Foxtrot LLC · Scott City, KSBuilt 2022 · S/N 8824N230WJCenter Ice Scouting LLC · Crestwood, KYBuilt 2007 · S/N 2539N2311VB & L Henry LLC · Chipley, FLBuilt 1997 · S/N E-3111N2317SSokoloff James T · Cambridge, MAS/N E-3117N2317VMay-Collier Aviation LLC · Atlanta, GABuilt 1998 · S/N E-3164N2318ATarpley Gary H · Seaford, VABuilt 1997 · S/N E-3118N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245N231ABEquinoxx Flight Systems LLC · Duluth, GABuilt 2020 · S/N 2090N231JPQuest Air Inc · Cocoa, FLBuilt 1975 · S/N 414-0628N231KYMorris Kevin William · Camden, SCBuilt 1980 · S/N 25-0293N231LLTen-Xray LLC · Woodside, NYBuilt 2002 · S/N 0199N231NPStiritz Thomas A · Spokane Valley, WAS/N 25-0111N231PTLobbytools Aviation LLC · Friday Harbor, WABuilt 1980 · S/N P21000551N231TPPorter Bryan · Argyle, TXBuilt 2023 · S/N 9160N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263N231WMA Davtian M D Medical Services Inc DBA · Glendale, CAS/N 0900N2320YBauer Steven M · Eliot, MEBuilt 2024 · S/N 10365N2323ECherokee Beech Boys LLC · Kennesaw, GABuilt 1998 · S/N E3187N2324AFst Aviation & Logistics LLC · Sheridan, WYBuilt 1997 · S/N E-3124N2326AValcourt Robert F · Chicopee, MABuilt 1998 · S/N E-3165N2326BRandigo LLC · Wilmington, DEBuilt 1978 · S/N U20604470N2327AN2327a LLC · Murrells Inlet, SCBuilt 1997 · S/N E-3127N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369N232CDNew Paul · Jackson, TNBuilt 2002 · S/N 0187N232CGG6 Aviation LLC · Lewisville, TXBuilt 2020 · S/N 2127N232DTChancellor Shares LLC · Liberal, KSBuilt 1979 · S/N 414A0232N232FJConstruct Air LLC · Osage Beach, MOBuilt 2002 · S/N 0338N232FXAvp II LLC · Winnetka, ILBuilt 1993 · S/N E-2772
Back to AD 2012-10-13