OpenAirDocs.org
AD 2007-24-13

Registered aircraft · 4,026

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:2007-24-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:2007-24-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.

N132MDA1 Aero Inc · Parkland, FLBuilt 2025 · S/N 10846N132RFTom-Wolverton Matthew J · Morris Plains, NJBuilt 2002 · S/N 0298N1333FMadrigales Jorge · Laredo, TXBuilt 2005 · S/N 1715N1336CMakson Leasing Co Inc · Salisbury, NCBuilt 2003 · S/N 0483N1347CBlue Ridge Aero Inc · Berryville, VABuilt 2003 · S/N 0536N134AJTimmermans Jamy · San Jose, CABuilt 2005 · S/N 1511N134CKZhukov Yuriy Olegovich · Harrisonburg, VABuilt 2010 · S/N 3690N134SRZabala Jaime · Naples, FLBuilt 2006 · S/N 1894N134TC134tc LLC · Oklahoma City, OKBuilt 2019 · S/N 4808N1358CBrad Influence Llp · Wahpeton, NDBuilt 2003 · S/N 0529N135DTDelta Tango Aviation LLC · Salt Lake City, UTBuilt 2007 · S/N 2690N135KDSkylight Aviation Corp Trustee · Wilmington, DEBuilt 2009 · S/N 3452N135MPDudjak Investments Group LLC · Sugar Land, TXBuilt 2023 · S/N 9615N135RPValiair Lc Trustee · Casper, WYS/N 3586N135SRGunnin Larry · Simpsonville, SCBuilt 2006 · S/N 1898N1360CPinnacle Aviation LLC · Valdosta, GABuilt 2003 · S/N 0518N1368CCarson Dale Etrustee · Murrieta, CABuilt 2003 · S/N 0538N136AKGamma2 Inc · San Diego, CAFirst renewal noticeBuilt 2010 · S/N 3510N136HHCirrus Design Corp · Duluth, MNBuilt 2019 · S/N 4865N1379C79 Charlie LLC · Knoxville, TNS/N 0541N137LUAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1021N137PEB & C Aero LLC · San Luis Obispo, CABuilt 2001 · S/N 0008N137SRForeman Guy W · Valparaiso, INS/N 1916N1382CBerman Aviation LLC · Tulsa, OKBuilt 2003 · S/N 0534N138CKMako Medical Laboratories LLC · Raleigh, NCBuilt 2009 · S/N 3492N138CRValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1584N138MCCherington Cirrus LLC · Belmont, MABuilt 2019 · S/N 4755N139CDCirrus Design Corp · Duluth, MNS/N 0820N139JMPegasus Medical Management LLC · Wilmington, DES/N 2742N13AUCirrus Design Corp · Duluth, MNS/N 11745N13MLM3l LLC · Smyrna, TNBuilt 2007 · S/N 2573N13PYMartinez De Garcia Linda M · Miami, FLBuilt 2012 · S/N 3872N1403CPinger Kevin · Palo Alto, CABuilt 2003 · S/N 0519N1408WLate10air LLC · Fullerton, CABuilt 2015 · S/N 4243N140BVGlobal Jetcare Inc · Brooksville, FLBuilt 2011 · S/N 3780N1416RSkyhawk LLC · Great Falls, VABuilt 2020 · S/N 4975N141ECDcomm Inc · Austin, TXBuilt 2007 · S/N 2556N141HTBazman Aviation LLC · Harbor Springs, MIBuilt 2006 · S/N 2219N142AKCirrus Design Corp · Duluth, MNS/N 11885N142BKCirrus Sr22 11508 Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11508N142CGlc Equipment Leasing LLC · Paragould, ARBuilt 2018 · S/N 4714N142CWCarbon Wing LLC · Fishers, INBuilt 2006 · S/N 1911N142DCirrus Design Corp · Knoxville, TNBuilt 2017 · S/N 4587N143CGavin Lauren Aviation LLC · Miami, FLBuilt 2008 · S/N 3224N1446CFour Six Chuck LLC · Maynard, MABuilt 2003 · S/N 0480N1447CAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2003 · S/N 0498N144TEEhlenbach Aviation LLC · Kildeer, ILBuilt 2007 · S/N 2507N1457CHillen Air Corp · Dothan, ALBuilt 2003 · S/N 0547N145AJKearns William A · Spokane, WABuilt 2006 · S/N 2082N145EJKovamees Carl · Middleton, MAS/N 3383
Back to AD 2007-24-13