AD 2012-24-03

Registered aircraft · 363

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-24-03')
    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-24-03')
  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.

N387AK387ak LLC · Anchorage, AKS/N 3730N390FDReach Air Medical Services LLC · Santa Rosa, CABuilt 2005 · S/N 9078N390NSNorthstar Trekking LLC · Juneau, AKBuilt 1992 · S/N 2615N392NSNorthstar Trekking LLC · Juneau, AKBuilt 2006 · S/N 4166N393NSNorth Star Trekking LLC · Juneau, AKBuilt 2009 · S/N 4762N399PHPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2008 · S/N 9224N39VATriple M Leasing LLC · Shreveport, LABuilt 2010 · S/N 9384N3PDSuffolk County Police Dept · Yaphank, NYBuilt 2006 · S/N 9094N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024N402CNChildren'S Hospital & Medical Center DBA · Omaha, NEBuilt 2013 · S/N 9570N403HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1999 · S/N 6570N405AMAris Aviation Group LLC · Henderson, NVBuilt 1995 · S/N 2833N405TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4476N4061GBristow LLC · Lake Charles, LABuilt 1997 · S/N 3051N406BCMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9863N406GFMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9880N4074EAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 2950N410CKCharm City Aviation LLC · Baltimore, MDBuilt 2004 · S/N 3793N420JABristow LLC · Lake Charles, LABuilt 2007 · S/N 4212N440SFOsf Aviation LLC · Peoria, ILBuilt 2011 · S/N 9457N444KLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2008 · S/N 9010N445CHEgleston Childrens Hospital At Emory Univ Inc DBA · Atlanta, GABuilt 2015 · S/N 9729N445DUMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9827N448AEShedhorn Construction Inc · Bozeman, MTBuilt 1999 · S/N 3210N448CHMetro Aviation Inc · Shreveport, LABuilt 2011 · S/N 9448N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615N450CCHosking Aviation Inc · Bountiful, UTBuilt 1983 · S/N 1682N452MHCharlotte Mecklenburg Hospital Authority DBA · Charlotte, NCBuilt 2007 · S/N 9122N453MHMemorial Hermann Health System · Houston, TXBuilt 2007 · S/N 9136N455MHMemorial Hermann Health System · Houston, TXBuilt 2008 · S/N 9161N456TKMemorial Hermann Health System · Houston, TXBuilt 2007 · S/N 9130N45UHUniversity Of Utah · Salt Lake City, UTBuilt 2012 · S/N 9529N461SAAir Twinlite Inc Trustee · Wilmington, DEBuilt 2002 · S/N 3605N46UHUniversity Of Utah · Salt Lake City, UTBuilt 2017 · S/N 9800N474LFWest Penn Allegheny Health System Inc · Pittsburgh, PABuilt 2009 · S/N 9301N47UHUniversity Of Utah · Salt Lake City, UTBuilt 2015 · S/N 9601N480LFGeisinger Medical Center · Danville, PABuilt 2012 · S/N 9502N481LFGeisinger Medical Center · Danville, PABuilt 2010 · S/N 9392N482LFGeisinger Medical Center · Danville, PABuilt 2007 · S/N 9118N483LFGeisinger Medical Center · Danville, PABuilt 2007 · S/N 9133N484LFGeisinger Medical Center · Danville, PABuilt 2009 · S/N 9259N485ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2010 · S/N 9348N485LFGeisinger Medical Center · Danville, PABuilt 2013 · S/N 9614N486LF7513 Helicopter Inc Trustee · Wilmington, DEBuilt 1995 · S/N 7513N487LFGeisinger Medical Center · Danville, PABuilt 2009 · S/N 9255N488LFSt Lukes University Health Network · Danville, PABuilt 2010 · S/N 9377N48SEPhi Health LLC · Tempe, AZBuilt 2005 · S/N 9071N490HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 9734N491HCBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 9878N492HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9805
Back to AD 2012-24-03