OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,307

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.

N1492CArrow Aviation Partners LLC · Crown Point, INBuilt 2003 · S/N 0567N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065N1495TRossi Aviation LLC · Mount Airy, MDBuilt 2025 · S/N 11029N149ARB-Cat Aviation LLC · Tulsa, OKBuilt 1983 · S/N 414A1006N149BW499 Bw LLC · Costa Mesa, CAS/N LIV-373N149CKValiair Limited Co Trustee · Casper, WYBuilt 2009 · S/N 3388N149DQuilliam Kevin · Arnold, MDBuilt 2004 · S/N 0835N149FGCda Management LLC · Keller, TXBuilt 2004 · S/N LIV-579N14ACLippert Bradley W · Crawford, COBuilt 1997 · S/N 29-0117N14CEFacility Concepts Developments LLC · Jackson, MSBuilt 1989 · S/N TH-1562N14CLValiair Ltd Co Trustee · Casper, WYBuilt 2003 · S/N L2K-203N14CXVortac LLC · Traverse City, MIBuilt 1988 · S/N 4608107N14DHDenisenkov Dmitry · Seattle, WABuilt 2008 · S/N 3000N14EXSorpresa LLC · Salem, ORS/N 15N14JDC340-340 LLC · Pinckney, MIBuilt 1974 · S/N 340-0340N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792N14JHRegistered aircraftBuilt 1998 · S/N TH-1845N14KEJust Got Real Cirrus LLC · Lake Havasu City, AZBuilt 2008 · S/N 3252N14MKBurdzy Christopher · Alton, NHBuilt 2006 · S/N 1801N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14PGI3 Cirrus Holding LLC · Houston, TXBuilt 2019 · S/N 1852N14WHWaypoints LLC · Mesa, AZS/N 3109N1500FGerhold Jeremy · Rosharon, TXS/N D-8552N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814N1501CUnderwriting Wave LLC · Woodland Hills, UTBuilt 2003 · S/N 0528N1508KWny Aero LLC · Orchard Park, NYBuilt 2010 · S/N 0042N150CFDesutter S Bryan · Manito, ILBuilt 1980 · S/N 340A1215N150GVy Holdings LLC · Midland, GABuilt 2025 · S/N 10723N150SCAnderson Thomas R · Seattle, WABuilt 1973 · S/N U20601958N150ZZSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2007 · S/N 2609N1516MWrubel David · Atlanta, GABuilt 1988 · S/N E-2459N15186N15186 LLC · Dyer, INBuilt 1988 · S/N E-2456N151ALCirrus Sr22t 11110 Inc Trustee · Wilmington, DEBuilt 2025 · S/N 11110N151CGN151cg Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0344N151JCFlying Scotsman Inc · Boston, MABuilt 2025 · S/N 11027N151LCNewberry Homes LLC · Port Orange, FLBuilt 2007 · S/N 42501N151PTTime Flies LLC · Fort Worth, TXBuilt 2004 · S/N L2K-118N151SRBas Part Sales LLC · Greeley, COBuilt 2006 · S/N 2151N151TCCtc Aviation LLC · Toccoa, GABuilt 2020 · S/N 2120N1522LGoetz Dennis D · Mason, OHBuilt 1988 · S/N E-2457N1525THamilton John D · Frederick, MDBuilt 2000 · S/N 29-0211N15278Zastrow Lyn · Prosper, TXBuilt 1990 · S/N E-2550N1527CSp Air LLC · Birmingham, IABuilt 2003 · S/N 0564N1528KBuck Daniel · Ashland, VABuilt 1988 · S/N E-2453N152BTCoho Aviation LLC · Hillsboro, ORBuilt 1980 · S/N P21000486N152CDPlane Crazy LLC · Bay Minette, ALBuilt 2007 · S/N 2894N152JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1966 · S/N D8322N152JTStork LLC · Winston Salem, NCBuilt 2014 · S/N 0751N152SBPegasus Aviation Partners LLC · Little Rock, ARBuilt 2004 · S/N 1146N152SDSt Regis Air LLC · Lancaster, PABuilt 2008 · S/N 3304
Back to AD 2012-10-13