AD 2011-05-08

Registered aircraft · 182

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:2011-05-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-05-08')
  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.

N194LLIndiana University Health Inc · Indianapolis, INBuilt 2010 · S/N 9357N195LLIndiana University Health Inc · Indianapolis, INBuilt 2008 · S/N 9226N198LLMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 9158N240SFOsf Aviation LLC · Peoria, ILBuilt 2010 · S/N 9403N261MHMetrohealth System · Cleveland, OHBuilt 2009 · S/N 9250N263MHMetrohealth System · Cleveland, OHBuilt 2009 · S/N 9311N266MHMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9877N267MHMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9879N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273N273NEMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 9586N282SArrow Aviation Company LLC · Broussard, LABuilt 1985 · S/N 760282N30EZHover Air LLC · Anchorage, AKFirst renewal noticeBuilt 2011 · S/N 7285N340SFOsf Aviation LLC · Peoria, ILBuilt 2010 · S/N 9411N350MPCity Of Memphis Police Department · Memphis, TNBuilt 2004 · S/N 3783N351HDT Scott Dunn Construction Inc · Phoenix, ORBuilt 2001 · S/N 3508N352RNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3664N353PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3722N354PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3690N357PAPathfinder Leasing LLC · Anchorage, AKBuilt 2003 · S/N 3675N358TVTiny Bubbles Aviation Inc · Pacoima, CABuilt 2004 · S/N 3788N365UCAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9246N373LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2006 · S/N 9099N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239N387AK387ak LLC · Anchorage, AKS/N 3730N390FDReach Air Medical Services LLC · Santa Rosa, CABuilt 2005 · S/N 9078N399PHPhi 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 9570N406BCMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9863N406GFMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9880N440SFOsf Aviation LLC · Peoria, ILBuilt 2011 · S/N 9457N445CHEgleston Childrens Hospital At Emory Univ Inc DBA · Atlanta, GABuilt 2015 · S/N 9729N445DUMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9827N448CHMetro Aviation Inc · Shreveport, LABuilt 2011 · S/N 9448N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615N452MHCharlotte 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 9529N46UHUniversity 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 9133
Back to AD 2011-05-08